Creating a pivot table based on a column that has a dropdown menu allowing multiple selections

cmhaug

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?

Isaac A.

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:

• How to create cross-tab report like Pivot table
• Combining Data from Pivot Tables and Sheets

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:

• Get started with Smartsheet Pivot App
• Preview, build, and edit a Pivot table

I hope this helps!

Cheers,
Isaac.