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
Check out the Formula Handbook template!