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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
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. 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 422 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives