Update Column Formula with Control Center

Hi,
I'm trying to update a column formula with control center. When I do Find/Replace and look at the test sheet, it's not updating.
Original Formula :=IF(Summary@row = true, "", [Amount I]@row + [Amount II]@row + [Amount III]@row - [Allowance I]@row - [Allowance II]@row)
New Formula: =IF(Summary@row = true, "", [Amount I]@row + [Amount II]@row + [Amount III]@row - [Allowance I]@row - [Allowance II]@row - [Spousal Allowance]@row)
Answers
-
I hope you're well and safe!
Unfortunately, it's not possible to do a Global Update on Column Formulas yet, but it's an excellentย idea!
Pleaseย submitย an Enhancement Request when you have a moment.
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 support the Community by marking it Insightful/Vote Up 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.
-
-
Yes, but all that you can do is fantastic.
Hang in there! ๐
โ Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up 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 was trying to run a global update to take out a column formula - I just got the same error :(
-
Hey @Automations 1 / @Andrรฉe Starรฅ !
See this link below โ if you use โModify Existing Columnโ the global update does change the column formula!
Global Updates Support for Column Formulas with Control Center | Smartsheet
-
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.
-
FYI... @ygoldgrab you wrote above "See this link below โ if you use โModify Existing Columnโ the global update does change the column formula!"
Perhaps you can change a column formula, but I was unable to completely REMOVE an entire column formula.
-
Just echoing / reinforcing @ygoldgrab's response and direction; editing the source sheet's column with the desired new column formula, then running the "Modify Existing Column" global update and selecting said column will carry the adjusted formula across all deployed structures. Wish I had read all the way through this thread a few nights back to reach that comment ๐.
-
I was hopeful when I read this post announcing support for this (in 2021, no less), but tonight while trying to update an existing column formula, I received this error in Control Center:
Does anyone know a specific trick to updating a column formula?
-
hello @Andrรฉe Starรฅ do you know if smarthseet already resolved this issue and global updates can be done to column formulas? it's 2025 :)
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)