Update Column Formula with Control Center

Automations 1

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)

Andrée Starå

Hi @Automations 1

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!

Automations 1

😔 another thing to add to the list of things Control Center can't do!

@Andrée Starå

Andrée Starå

@Automations 1

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!

ygoldgrab

I was trying to run a global update to take out a column formula - I just got the same error :(

ygoldgrab

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

Andrée Starå

@ygoldgrab

Excellent!

Thanks for sharing!

Automations 1

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.

Kyle Chipman

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 😋.

Scott Peters

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?