-
Adding Cell Links to Existing Profile Data
For a period of time, 2 profile data fields were incorrectly set to One Time Write, rather than Cell Link. I need to correct this and add the Cell Link behavior for these 2 fields from the intake sheet to metadata sheets. I have tried the Add Profile Data trick to apply a pseudo Update Reporting Global Update, however that…
-
Include additional advanced formatting options in Global Updates
Per this help article, the following aren't available to configure when making column-related Global Updates using Control Center: Currency Percentage Thousands separator Decimal places Date format This makes the implementation feel half finished, as you still have to go into each sheet and make adjustments. These should…
-
Multi-Select Projects to "Update Reporting" in Control Center
Whenever a change is made to a blueprint in control center we are already disadvantaged by only being able to apply this change to future projects created from the blueprint. We can however, using Global Updates retroactively add certain rows to summary sheets that can be a proxy to apply changes to existing projects.…
-
Missing Data on Metric Widget During a Dashboard Global Update
Hello, I recently ran a global update on a dashboard in a child blueprint and found all existing projects now show a "missing data" in a metric widget. New provisioned projects do not have this issue. The metric is pulled from a sheet cell that is part of the project blueprint. The source sheet has not been renamed or…
-
Control Center Global Update Text vs Numeric
I'm working in Control Center on a Global update to change a field from "N/A" to 0 (aka zero). When testing the update I noticed that it changes to the text of "0" as it's left aligned vs right aligned. Any ideas how to update from a Text to Numeric via Global Updates? I've tried different variations to force numeric:…
-
Control Centre Global Update
Currently, when using the sheet global update option for inserting a column, we are restricted to using a single date format. It would be helpful if we could use options for the modified date as well.
-
Task Sheet Global Update
I have updated my "health" column in my task sheet with new formulas and new symbols. I am trying to figure out how to update all my existing projects to have the same symbols and formulas by doing a global update. I chose "find and replace" then my task sheet. What should I enter as my find string?
-
Smartsheet Control Center - Delete Predecessors
Hi all! I have a question about control center. I want to make a global update but it's not possible in a predecessors column. Context: ~1200 projects already provisioned ~500 have data related to the predecessors we don't want to lose So I THINK I can remove the predecessors from the blueprint sheet itself and then…
-
Updating the Year
Hello, I have a schedule created for 2024 and would like to update all the dates to 2025. I tried using find/replace and the values */24 with */25, but it I received a message saying no matches found. What else can i do? Any tips are appreciated.
-
Global Updates available for all sheets
It would be awesome to have Global Updates available for all sheets not just control center. Example: Needing to add the same column to several different sheets and being able to select the sheets you want to add them too. This would cut down on the manual process for updating similar kinds of sheets that are not…
