How can I count the number of items selected within a multi-select drop-down...?

Options

How can I count the number of items selected within a multi-select drop-down and multiply that amount by 25?

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Options

    Hi @adelmans,

    If you're wanting to do it row by row:

    =COUNTM([Dropdown column]@row) * 25

    For the whole column:

    =COUNTM([Dropdown column]:[Dropdown column]) * 25

    These will count the number of selected items.

    Hope this helps, if you've any questions or I've missed something then just post!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!