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

Options

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




Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓
    Options

    @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")

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!