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

How to add varying months to varying dates?
I am really having trouble getting a formula to work here. I've gone through a number of support articles, but I'm just missing something. I want a formula that looks at Date Contract Executed and it adds Months Until Expiration to produce a new Date of Expiration. I've got my date columns as dates and the middle column as…
How Can I Calculate the Number of Hours between Two Different Time Formula Values?
I have a form that collects times of day, into a sheet via a dropdown List of times (9:00 AM, 9:30 AM, 10:00 AM, ect). I have converted these values into a time using the TIME function. So now I have 4 columns: Start Time (dropdown list value from the form) End Time (dropdown list value from the form) Start Time 12 Hr…
Automatic Phase from WorkBreakdown
Hello all! I'm modifying the Simple Portfolio Work Breakdown Schedule and having a little trouble. I like the way the Work Breakdown structure works but I'd really like an automatic way to track which Phase something is in. I know I could just add a column and manually select which Phase tasks and sub tasks are in, but I'm…