"Incorrect Argument Set" error

Options

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")


Thanks!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!