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.
Capability of push Sheet Summary for provisioned project with formula contains sheet reference formula
It would be helpful if you could use SCC global updates to update/work with the sheet summary section of a sheet.
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
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
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!
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. 😫
I agree, this would be a great enhancement. I just discovered a use case for this and wish it was an option.
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?