Countifs no longer working

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

Hello,

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!!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!