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 at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
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 at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
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 at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives