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
-
As long as there are two rows of the same hierarchy that contain the formula immediately above the new row, it should autofill down.
-
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:Β
I hope that helps!
Have a fantastic week!
Best,
AndrΓ©e StarΓ₯
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I'll check to see that I am meeting the conditions to trigger an auto fill formula and see if it persists. Thank you!
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!