Sign in to submit new ideas and vote
Get Started

Sheet Summary in Control Center Global Updates

SPIPMO
SPIPMO ✭✭✭✭

It would greatly enhance the functionality of the Control Center if the Sheet Summary could be incorporated into the Global Updates feature. In contrast to utilizing a "Metadata" sheet in the Project Blueprint, I've opted for the more convenient Sheet Summary to store essential metrics.

While the metadata approach can be cumbersome for referencing metrics, the Sheet Summary offers a more streamlined way to access these metrics. Given the presence of 18 sheets in the project blueprint, I've chosen to employ the Sheet Summary for linking data instead of relying on metadata. However, managing modifications or additions to fields within the Sheet Summary can be a bit cumbersome since it's currently not integrated into the Control Center's global updates.

I'm hopeful that in the future, the Sheet Summary can be seamlessly incorporated into the Control Center's global updates functionality. This would significantly improve efficiency when managing changes to metrics and data fields.

33
33 votes

Idea Submitted · Last Updated

Comments

  • Chizu Hieida
    Chizu Hieida Overachievers

    Capability of push Sheet Summary for provisioned project with formula contains sheet reference formula

  • Jeff_Berman
    Jeff_Berman ✭✭✭✭

    It would be helpful if you could use SCC global updates to update/work with the sheet summary section of a sheet.

  • Joe Goetschel
    Joe Goetschel ✭✭✭✭✭✭

    This is an important need. In short, I have no choice but to use Sheet Summery to leverage a column formula at the row level. Today I can add a column but if I need to reference data in the sheet summary I can not use Global update unless I go to 500+ projects and add the Sheet summary I need in order to add the column etc.

    Joe Goetschel | Associate Director, Smartsheet

    CrossCountry Consulting - Smartsheet Partner

    Email me!

    "The only real limitation of Smartsheet is the level of effort required to achieve your goal."

  • Aleksandr Wellner
    edited 10/30/24

    As my team is starting to use Smartsheet Control Center more to standardize ongoing projects, two areas for global update improvements came up. As of now, we are unable to globally update fields in the sheet summary area, and we cannot add the same row to a set of templated projects. If both of these could be added as global update abilities in the future, that would be great!


    Thank you!

  • Chizu Hieida
    Chizu Hieida Overachievers
    edited 10/30/24

    I would love this 100%. We have this large Blueprint and it's been about 2 years = we have over 370 projects with this blueprint. One of the sheet did not have Summary Row. Our process changed recently and I'll have to manually add this row to each projects before I can even use the Profile Data Global update. I'd love to be able to add Summary row so I can utilize global update instead of manually going through 370 projects. 😫

  • Julie Fortney
    Julie Fortney Overachievers

    I agree, this would be a great enhancement. I just discovered a use case for this and wish it was an option.

  • Gopikrishna Mamidipudi
    Gopikrishna Mamidipudi ✭✭✭✭✭
    edited 10/30/24

    I'm a relatively new user of the Smartsheet Control Center and have a very similar issue. Has anything changed? I need to make changes to the Sheet Summary formulas and also add a new Sheet Summary Column. I also do not see the ability to create a Sheet Summary report. What changed?