Keeping formulas when pasting rows of data

samgiese ✭✭
edited 08/17/20 in Formulas and Functions

I',m in a bit of a pickle with one of our sheets. So right now I've got a sheet that is being filled in automatically with a script that I made. It is taking a CSV that is constantly growing, converting it into an excel doc, and then copying & pasting the entire thing into a smartsheet. This works great for the most part, except for a column that utilized a formula that needs to be dragged down every time new data is pasted.

Is there a workaround for this issue? Maybe a different approach of formula?

Right now the TOTAL Cat column is counting how many cells in the row have an x in them to the left (basically a checkbox cell) & the Count of REG box is seeing how many rows total actually have one or more x in them. I figured out a way around the TOTAL Cat formula, but am stuck on the Count of REG & it's total up top. Can anyone help me find a way around this please?

Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!