I'm trying to set up a column that counts how many multiple choices are selected. What's the best way to do this?
For example, I have a stock shelf column that is a choice pills type, I select this shelf has soap, shampoo and toothbrush. A second shelf has just soap selected. I'm trying to get a calculation column that tells me how many were selected, so like the first item would come up as 3, then second shelf would say 1. Hope that makes sense!