Control Center add new column not formatted with word wrap
I have added a new column to one of my template sheets. It is a column formula that combines text from multiple cells. Because it may result in long text strings, I have set the column to word wrap. I did this by highlighting the entire column (selecting the header) in the template, and applying wrap. In the template, it clearly is applied and works.
In control center, I have created a new global update to add a new column, and select "use an existing column from the template". When I apply it and run the test, it does apply the update, and the formulas work, however, wrap is not applied in the test sheet.
Initially I had the column hidden in the template and intended to deploy it as hidden. But my experience with global updates is that it is seriously glitchy. Especially when the global update includes a column formula. So I set it to not be hidden, both in the template and the update, and that did not help.
I have gone into the template, turned off word wrap, and saved the template. Then reapplied it to the column and saved again. Then refreshed control center and tried the update again. Still no luck.
I have closed completely out of smartsheet and control center, and tried all the above again. No luck.
I do not want to deploy a new column to over 500 sheets and then have to open them each individually to apply wrap.
General note if Smartsheet staff is listening... global updates is glitchy at best. This formatting problem plagues everything I do with global updates in control center. And we use it a lot. We are in our second year of using smartsheet, so our templates and structure are still growing and being updated. I can be 100% certain that I have set up a new column with wrap, currency, percent, or other formats... only for it to deploy as generic unformatted text. I know that the formatting options in control center global updates are limited, but all the literature clearly states that if the formatting is already applied, it will push it through. For example: from Control Center Global Updates: Columns | Smartsheet Learning Center
- While formatting that’s been explicitly applied to the column will be pushed to existing projects, Conditional Formatting rules will not be copied to the project sheets.
This is clearly not my experience. I grow weary of reformatting columns sheet by sheet when the update fails to do it properly.
Any advise appreciated!