Formulas and Newly Added Rows

KMan1190 · 02/10/20

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 · 02/10/20

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å · 02/10/20

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:

Use or Override Automatic Formatting and Formula Autofill | Smartsheet Learning Center

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

Automatic formatting and formula autofill are related features that persist patterns of formatting or formulas when you add content to a sheet.

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

KMan1190 · 02/10/20

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å · 02/11/20

@KMan1190

Happy to help!

Let us know how it goes!

Formulas and Functions

Formulas and Functions

Formulas and Newly Added Rows

Answers

Use or Override Automatic Formatting and Formula Autofill | Smartsheet Learning Center

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

How to return the last recorded date in a column?

What am I doing wrong?

Nested IF Statements to Determine Priority