Sheet Summary formula for counting unique values within a multi-select dropdown column?

I am trying to count the number of unique systems used within a workflow. I have dozens of possible internal systems listed within a restricted, multi-select, dropdown menu. As these systems are populated to the grid (sometimes multiple within a single field), does anyone have a formula that can generate the result below?

Box 1: Outlook

Box 2: Word

Box 3: Outlook, Word, Adobe

Box 4: Adobe

I'd like the sheet summary to say "3" because there are three unique systems being used (i.e. Outlook, Word, Adobe). Using COUNTM is giving me ""4" because it's counting Box 3 a distinct cell.

Any ideas?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!