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:[email protected] | 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:[email protected] | 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:[email protected] | 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 😋.
