Is there a way to make Data Shuffle Keep Formulas?
KCMiller
โญ
I have a sheet I am using to track hours on various projects for reporting purposes. There are certain rows where I use equations like =Sum(Children()). When using data shuffle to offload these rows, the data gets saved as numbers and not equations. Naturally when I pull the data back into smartsheet, it pulls only the data and rewrites the equations with numbers.
Answers
-
There isnt based upon what I have found. You would need to import into a sheet then copy through automation to another grid with the formulas as helper columns (column formuals). It looks like Data Shuttle removes all formating of anytype when importing into Smartsheet through data shuttle. You can import them manually but not through Data Shuttle.
