countifs formula stopped working


Hello All, 

Did something recently change?  I have a dashboard that leverages a sheet for various counts.  It has been working.  I was away on vacation and they are no longer working thowing and invalid error.

=COUNTIFS({Aimbridge Report Issues (Resolved)}, 0) – 10

=COUNTIFS({Aimbridge Report Issues (Resolved)}, 0, {Aimbridge Report Issues Range 1}, "Duplicate"




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!