"Incorrect Argument Set" error

The following formula works:

=COUNTIFS({Sales & Leads Box}, 1, {Month created}, "June", {Year}, "2022")

However, I'm getting an "Incorrect Argument Set" error when I try to add in one more criteria to this formula and not sure why:

=COUNTIFS({Sales & Leads Box}, 1, {Lead Category}, "Verified Lead", {Month created}, "May", {Year}, "2022")



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!