Countifs no longer working

Nwest ✭✭
edited 09/07/23 in Formulas and Functions


I have a countifs formula that was working and is no longer...

This is for my "metrics" sheet so the information is being pulled from the Garage Access Issues Log onto another sheet so I can use it in a Dashboard.

I'm trying to count how many issues are showing as unresolved and not archived. Both the 'Resolved' and 'Archived' 'columns are checkboxes. Below is the formula I have.

=COUNTIFS({Garage Access Issues Log Resolve}, =0, {Garage Access Issues Log Archive}, 0)

Below are all the columns of the source sheet if that helps

Thank you in advance!!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!