Pivot table with multiple items in 1 cell

TLDR: Is there a way for the pivot table to add up multiple drop down options within a cell rather than treating multiple selections as 1 category?


I am setting up a quality check sheet in Smartsheet that requires an inspector to check all the reasons a part failed. he can select from 12 options in a drop down and he can select multiple options. Id like to have this go into a pivot table so we can see our top hitters, but the problem is the pivot table does not split the multiple selections within cells.

for example, if we have failures with cell 1 having failure A, Cell 2 failure B, cell 3 with failure A & B, smart sheet doesnt sum a pivot table with 2 failures for A and 2 for B. Instead it says there is 1 for A, 1 for B, and 1 for AB. This isnt very helpful for my analysis. Is there a way around this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!