How to effectively use COUNTIF with multiselect column?


I'm trying to count each unique value selected in any given row of the column, however, the selected cell is coming back as one long string.

How do I count only the unique values, programmatically? I'm using the formulas shared for creating a list of distinct values given any column, if that helps (I can't remember where that post went to).

In my example, line 12 is "New Chair Install" and "Tickets". However, it's clearly coming through as just the one string as I mentioned earlier. Line 11 is "Remote Work" and "Tickets", but still a single string. I want them to be their own respective unique values. That's what I'm trying to solve.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!