Creating a pivot table based on a column that has a dropdown menu allowing multiple selections
I am trying to create a pivot table based on a column that has a dropdown menu allowing multiple selections. Is there a way to do this cleanly so that the pivot table just pulls each individual option instead of including each unique variation of multiple selections?
Answers
-
Hi @cmhaug!
I haven't personally created a pivot table without using the Pivot App, but it might be possible to achieve something similar by combining functions in formulas and cross-sheet references.
I've found a couple of related threads that might be helpful for this topic:
If you could share some mock data with the same structure as yours, it would be helpful for the community to provide more specific advice.
Also, here’s more information on the Pivot App:
I hope this helps!
Cheers,
Isaac.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
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives