Multi-Selects and COUNTIFS

Amy Evans

Hello,

I have a column with multi-selections. Can you help me with a formula that will count the number of selections and display the symbol "Half" when there are more than one selection counted?

Multi-Select.png

Thanks,

Amy

Paul Newcome

You would need to incorporate the COUNTM function.

=IF(COUNTM([Column Name]@row)> 1, "Half")

Paul Newcome

You would need to incorporate the COUNTM function.

=IF(COUNTM([Column Name]@row)> 1, "Half")

Amy Evans

Thank you! I haven't used COUNTM before.

Paul Newcome

Happy to help. 👍️