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

Heather Taylor · 10/18/21

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?

Kelly Moore · 10/18/21

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

Kelly Moore · 10/18/21

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

Heather Taylor · 10/18/21

@Kelly Moore - that worked! Thank you so much!!!

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

Best Answer

Answers

Help Article Resources

Categories