formula to add a checkbox in one column if another column is updated with multiple items?

If a column is set up as multiple drop down options, I’d like a formula in another column (checkbox) to check the box if more than one selection is made. Is this possible?

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey @Heather Taylor

    The CountM function counts items in multiselect dropdown columns. You can use this function to look for rows with a value greater than 1.

    =IF(COUNTM([dropdown column]@row) > 1, 1)

    Be sure to edit this formula to match the name of your actual column

    cheers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!