Pivot App in Control Center?
Good morning! Has anyone been successful in having pivots within control center that auto-update as part of the provisioning process? If they are based on dynamic scope reports?
Best Answer
-
Hi @Chris Hallo
Good morning! Yes, you can create a Pivot sheet using an SCC Dynamic Scope Report as the source. When a new project is provisioned, the Report will automatically bring in the data that you've specified based on the Report set-up and your blueprint configuration.
Then after the Report has been updated, the Pivot will run (on your specified cadence) and it will include this new information. Keep in mind that when you're using a Report as a source for a Pivot sheet, the fastest frequency timing you can set is 1hour (there is no "update immediately" for a Report, that's only available with a source Sheet).
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Answers
-
Hi @Chris Hallo
Good morning! Yes, you can create a Pivot sheet using an SCC Dynamic Scope Report as the source. When a new project is provisioned, the Report will automatically bring in the data that you've specified based on the Report set-up and your blueprint configuration.
Then after the Report has been updated, the Pivot will run (on your specified cadence) and it will include this new information. Keep in mind that when you're using a Report as a source for a Pivot sheet, the fastest frequency timing you can set is 1hour (there is no "update immediately" for a Report, that's only available with a source Sheet).
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
Thanks, @Genevieve P. I was getting conflicting information from someone on the Smartsheet consultant side.
-
No problem!
It depends on how you're using Pivot with Control Center (SCC). SCC isn't able to automatically create Pivot workflows, they don't connect in that way. However Pivot can use any Smartsheet Report or Sheet as the source, so if your Report is being automatically updated via SCC then the Pivot will eventually update, too. 🙂
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives