Count formula doesn't seem to be working in Checkbox column.

Deepa A

Hi,

Refer screenshot, I am expecting the formula to return blank till all six checkboxes are checked. However it is returning 'All Updated, even though none of the checkboxes are checked. It was working till last month, something seems to have changed this month. Any help will be gratefully received!

Deepa

Jeff Reisman

@Deepa A

There was a change made probably a year or more ago that affected the way COUNT works with checkbox and other Boolean columns. So now you need to use COUNTIF or COUNTIFS to specify that you only want to count the checked boxes (i.e. the cells equal to 1 or true):

=IF(COUNTIFS([Complete/Approved]2:Complete/Approved]7, 1) = 6, "All Updated")

Jeff Reisman

@Deepa A

There was a change made probably a year or more ago that affected the way COUNT works with checkbox and other Boolean columns. So now you need to use COUNTIF or COUNTIFS to specify that you only want to count the checked boxes (i.e. the cells equal to 1 or true):

=IF(COUNTIFS([Complete/Approved]2:Complete/Approved]7, 1) = 6, "All Updated")

Deepa A

Hi Jeff, thank you very much, it works!