Counting options selected in Multi-Select Column

DuayneB

DuayneB ✭✭

08/08/23 in Formulas and Functions

Is there a way to count the number of options selected in a multi-select column in another column?

Column3 here has the result we are looking for.

0 ·

Best Answer

Darren Mullen ✭✭✭✭✭✭

08/08/23 Answer ✓

@DuayneB Use the COUNTM() function

Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
0 · Share on Facebook Share on Twitter

Answers

Darren Mullen ✭✭✭✭✭✭

08/08/23 Answer ✓

@DuayneB Use the COUNTM() function

Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
0 · Share on Facebook Share on Twitter
DuayneB ✭✭

08/08/23

Thanks! I saw the request for that function, but I didn't think it had happened yet. That was easy.

1 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Auto number
I'd like a document numbering intake form that assigns an auto number based on a series of selections. How best to do that within the form/auto column?
How to sort by the summary count in my row report from Highest to Lowest?
SUMIFS when date cell ISBLANK
I'm trying to add "if date cell is blank" criteria to my SUMIFS formula, but get "INCORRECT ARGUMENT SET" =SUMIFS({EBOM - 4" CONDUIT QTY}, {EBOM - 4" JOINT TYPE}, "GSK", (ISBLANK({EBOM - ACTUAL PROD DATE}))) What am I doing wrong?