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?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives