Formula Won't work

edited 01/04/24 in Formulas and Functions

What am I doing wrong? I can't get this COUNTIFS formula to work!!! I have tired so many iterations.

A note that the "Opportunity For" and "Cycle" are referencing a column in a sheet.

This works: =COUNTIFS({Opportunity For}, HAS(@cell, "Minority"))

This works: =COUNTIFS({Cycle}, HAS(@cell, "FY24"))

I CAN'T GET THIS TO WORK: =COUNTIFS({Opportunity For}, HAS(@cell, "Minority"), [{Cycle}, HAS(@cell, "FY24")])

Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!