"#NO MATCH" Error

Hi @Paul Newcome,

I was using "COUNTIFS" formulas and they were working completely fine until today all of them are giving me an "#NO MATCH" error. Everything seems fine with the sheet and the formulas. Would you happen to know why this might be happening.

Formula: =COUNTIFS(Status:Status, OR(@cell = "Requested", @cell = "Demoed"), [Automation Category]:[Automation Category], OR(@cell = "Data Processing", @cell = "Data Visualization", @cell = "Robotics", @cell = "Workflow"))

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!