Column formulas and Global Updates

Chris Mondeau

Hi All!

I've tried adding a new column from a template (with a column formula), but am getting an error.

If I remove the column formula in the blueprint it works as expected. Am I doing something wrong, or has this not been updated in SCC yet?

Thanks!

Brian Besand - Smartsheet

Hey Chris! Global Updates doesn't currently support column formulas, so you can't push out an update to existing projects to include column formulas. If you build column formulas into your blueprint, all projects moving forward will be provisioned with that column formula.

Chris Mondeau

@Brian Besand - Smartsheet coolio, thanks for the update!

Jennifer Jones

Hi Brian,

I have a gazillion columns I would like to update with column formulas. Are global updates with column formulas coming in the near future? If so, that would be awesome and I'll wait for the update. If not... I might as well just get started.

Cheers,

JJ

Nju yyui

Definitely see how that may be now not worth the effort. We solved that issue with the aid of the usage of Data Uploader link. The procedure is a chunk convoluted however it labored for us. Goes like this:

ScottBaker

Hi folks, I am building a solution for this at superglobalupdates.com. At the time I'm posting this, it is in beta but I've got Convert to Column Formula working. If anyone would be interested in being a beta tester for me, there is a form to sign up on the site.