Multiple checkboxes in one cell - Formula for True

Shawn Church

I have a column asking three questions with the option to check one or all. Is there a formula to test if all checkboxes in one cell have been checked? I would like to apply the fomula to a symobol column where if all boxes are checked it will return a "true" value.

Nick Korna

Hi @Shawn Church,

You can do this with the COUNTM function.

=IF(COUNTM[Question]@row =3, 1 ,0)

Substitute the 1 and 0 with your symbol preferences.

Nick Korna

Hi @Shawn Church,

You can do this with the COUNTM function.

=IF(COUNTM[Question]@row =3, 1 ,0)

Substitute the 1 and 0 with your symbol preferences.

Shawn Church

Thanks! That worked.

Shawn Church

Follow up question....

The formula seems to work, however, it is only returning text values and not the symbol. Here is my formula:

=IF(COUNTM(Question@row) = 3, "yes", IF(COUNTM(Question@row) = 0, "no", IF(COUNTM(Question@row) > 0, "hold")))

What am I doing wrong?

Nick Korna

It's very simple to fix: you need to capitalise the words (e.g. "yes" to "Yes") and the symbols should show up correctly.