Modifying rows in a form entry sheet with formulas
Hello everyone,
I have a problem when I change some date in rows in my sheet, here is the example :
- A user fill information in a form, and then a new row is added in the sheet related to the form
- On that sheet, there are a lot columns that have pre-defined formulas
- I have put the new form entries parameter on the top of my sheet so each time a new row is added, it is added on the top.
As I understood, If I change the data in a formula column in the most recent row (on the top), it will affect all the new rows entries in the future, but if I change the data in a formula column in any other row it will not affect all the new rows .
Do you know how I could prevent this from happening and keep my formulas "freeze" whatever happens ?
I was thinking about column formula new feature, but I want to be able to change formula in a row after submission..
Thank you very much for your help !
Corentin
Best Answer
-
The new row will be auto-filled with the formulas if there are two rows below/above with the same formulas and the same level of hierarchy.
More details:
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:Β
Also, if possible, I'd recommend using the new Column Formula because then it will always work.
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
β Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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.
Answers
-
The new row will be auto-filled with the formulas if there are two rows below/above with the same formulas and the same level of hierarchy.
More details:
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:Β
Also, if possible, I'd recommend using the new Column Formula because then it will always work.
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
β Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 203 Use Cases
- 515 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives