Formatting not transferring...

MaryBethLane

I am not seeing my formatting transfer in a new workflow. When I choose the parse option it still does not transfer. Any ideas?

Support from Sheetgo

MaryBethLane can you tell me more about source and destination? What file types are they?

Are you consolidating? Are you filtering?

That’s all the information I need, please, to help you.

Thanks!

MaryBethLane

Hi Bobby, I am trying to back up two google sheets documents. I created a work flow and selected transfer or parse data and formatting…but the dates and currencies don’t transfer…

Support from Sheetgo

MaryBethLane unless you are consolidating those two, dates and currencies should fly over properly.

Mind sharing your workflow with my email robert@sheetgo.com?

Happy to take a look and debug for you!

MaryBethLane

Okay, I’ll send you an email now. I did an annoying work around but I still don’t know how to get it to work in the future for transferring formatting numbers and text/color. Can you look at all of it and let me know steps for adding more workflows. I had to clear formatting and select plain text under format for each document I needed to backup.

Support from Sheetgo

MaryBethLane thanks for sharing! Let’s review them step by step.

On the “Sheetgo_ACTIVE_Price” connection, you also need to enable cell color and text formatting if you want to transfer colors as well.

I just enabled it and ran the connection. Please review and let me know if this is what you were looking for!

MaryBethLane

Okay, that was part of it. Thank you for doing that. Are all tabs enabled for cell color and text formatting now.

Support from Sheetgo

MaryBethLane I haven’t enabled it on all. First wanted to get your feedback. Glad it’s working now! :)

MaryBethLane

Bobby can you look at one more thing? In the sheetgo app it shows I have 12 active connections. They are not labeled. I deleted three of them but not sure which ones to delete on connection side. I have nine files I need backed up. But don’t want 12 connections running every day using all my transfers. How do I test to see what’s what?

Support from Sheetgo

MaryBethLane go and edit each of the connections. Check the source section to get a better understanding which one that is.

Next, click the current connection name to rename it. :)

Example:

Eugenia

If you rename the connections and run it, this will generate a new tab on the destination, right @Support from Sheetgo ?

Support from Sheetgo

Eugenia I think she just wants to change the connection label. In this case it wouldn’t generate a new tab right?