How to change a formula without affecting previous existing cells
I have a workflow in which I am using the If formula(=IF([Funding Stream]@row = "BCP Core", "Kellys", "Mwamba")). I would however want to change the name "Kellyz" to "Elisa" but without affecting the previous results which already have the name "Kellyz"
Answers
-
Hi @Taonga
I hope you're well and safe!
Are you using a Column Formula?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
β Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. 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.
-
Hi @AndrΓ©e StarΓ₯, yes, i am using a column formula.
-
Then you'd only need to convert it back to a cell formula and then make the change for the rows where you want the new one.
Would that work?
β Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. 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.
-
I have a workflow/automation running on this sheet, so when a new line is added, how can i avoid dragging the formula each time this happens but for it to automatically populate the cell formula for the new line?
Not sure if i am making sense.
-
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:Β
Did that work/help?
β Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. 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.
-
AndrΓ©e StarΓ₯ : Thanks for the answer!!
-
Hi,
I hope you're well and safe!
I'm glad to hear that it's helpful, and always happy to help!
Be safe, and have a fantastic day!
Best,
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
β Did my comment(s) help/answer your question or solve your problem? Please support the Community and me byΒ marking it - Insightful π‘- Vote Up β¬οΈ - Aweseome β€οΈ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!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.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 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!