Formulas and Newly Added Rows

Hi,

Our case application requires a lot of movement of rows between sheets, and I am having an issue with Formulas not automatically applying to newly added rows which necessitates going into the sheets and manually clicking and dragging the formulas to newly added rows from the rows above (time consuming with multiple formulas in place:( ).

Would love to be able to move rows between sheets while safely relying on the formulas to be applied to newly added rows...Any ideas for ways to ensure the formulas move down automatically? or is there another workaround which has worked for you?

Thanks in advance.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!