Formulas and Newly Added Rows

KMan1190

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.

Paul Newcome

As long as there are two rows of the same hierarchy that contain the formula immediately above the new row, it should autofill down.

Andrée Starå

Hi,

As long as the below conditions are met it should work.

If the formula structure is the same above/below the Formula Autofill will add the formula(s) automatically.

Conditions That Trigger Formula Autofill

You’ll see formulas populate automatically when you type in a newly inserted or blank row that is:

• Directly between two others that contain the same formula in adjacent cells.
• At the topmost of the sheet if it’s above two rows that have the same formula in adjacent cells. (This includes rows inserted from a form.)
• At the bottommost of the sheet if it’s below two rows that have the same formula in adjacent cells. (This includes rows inserted from a form.)
• Above or below a single row that is between blank rows and has formulas.

More info: 

https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

KMan1190

I'll check to see that I am meeting the conditions to trigger an auto fill formula and see if it persists. Thank you!

Andrée Starå

@KMan1190

Happy to help!

Let us know how it goes!