Add Ons and Integrations
Add Ons and Integrations
Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.
Pivot Help
I have a sheet with a hierarchy broken down by region and country. Under each country is the name of a worker. I'm trying to create a pivot to count the number of workers per region and per county. I've tried is so many different ways and cannot figure out what to select for the rows, columns and values.
Thanks!
Answers
-
In my experience, the Pivot App doesn't work super well with Hierarchy, but you might be able to get a work-around by adding a helper column or two to help group items within the pivot.
Alternatively, if you're able to change the sheet structure to remove hierarchy and build a flat table, you might be able to use the new group and summary functions within Smartsheet's reports and avoid the pivot-app altogether.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
