Updating references on a template and deploying changes via SCC
Hi all,
I am trying to update an existing metadata sheet in our solution build via SCC. I was able to make the changes on the sheet itself and have applied it at the template and test with an existing team dashboard. I realized after I will need to use SCC to actually make the change and then to all the retroactive sheets in our environment. 1 team metadata sheet exists for our various teams, as they are used for dashboarding and other analytics
Our original template sheet has 1 reference called "Department Rollup Health | Health", used in the formula =COUNTIF({Department Project Rollup | Health}, "Green") as seen in screenshot #1 below:
Screenshot #1
I am adding in a new reference called "Department Rollup Health | Current Status" to count another column called "Current Status" on the referenced sheet, using the formula =COUNTIF({Department Project Rollup | Current Status}, "Project (In-Progress)") (see screenshot #2 below)
Screenshot #2
Where I am now stuck is how to make these changes in SCC. I do not want to remove or replace the existing references as they are being used, but add those references to the sheet and update the references as seen in screenshot #2.
When I am using global update, I am unsure how to make these changes to only individual cells. I am trying to update the formulas (screenshot #3) - once again, I do not want to replace the existing formula and reference on every cell with the old value, only on individually selected cell:
Any ideas how I can do this in SCC, so I am not manually updating all our sheets to work? Thanks!
Answers
-
If you are creating a new cross sheet reference, you will have to update this manually. You can roll out the formula itself via control center, but since the reference does not exist on the other sheets you will still have to manually go into every sheet and update this bit anyway.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Paul,
Thanks for the insight. So what would be the correct order to deploy this? Is it that we have to create the reference on every sheet and manually select the cell we want to update it?
-
It is going to be up to you. Since you have to go into every sheet anyway, you can just go into each sheet and update the formula manually. The other option would be to deploy a find/replace global update to swap out the formula and then go into every sheet and manually create the cross sheet reference.
Either way you are going to have to make some manual change to every single sheet this affects.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thanks Paul, we're going through the manual process for now.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!