COUNTIF functions returning 0

I am trying to create a countif formula that references one other sheet. I want it to pull with 2 different criteria if the column = 01 and the second column = "open".


=COUNTIFS({Dump: OPEN AND CLOSED REQS Range 1}, "01", {Dump: OPEN AND CLOSED REQS Range 2}, "Open"). This function returns 0 when I know there is a few that have 01 . I also tried inserting 01, 02, 03 ,04 and I still get 0 rather than the correct number.


Please let me know if you need more information.


Best Answer

  • Courtney S.
    Courtney S. ✭✭✭✭✭
    Answer ✓

    Someone else on a different post I recall got a COUNTIFS function to work better by adding "@cell=" in the criterion portion even though the official Smartsheet function page doesn't mention that. Give it a try, let me know if that does work?

    =COUNTIFS({Dump: OPEN AND CLOSED REQS Range 1}, @cell=1, {Dump: OPEN AND CLOSED REQS Range 2}, @cell="Open")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!