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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • summetg
    summetg ✭✭

    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?

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • summetg
    summetg ✭✭

    Thanks Paul, we're going through the manual process for now.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!