COUNTIFS to include cells with text

Rochelle_B ✭✭✭
edited 12/09/19 in Formulas and Functions

I need to create a cross-sheet formula that counts the number of entries for a month and if there is text in another column. 

I've come up with the formula below, but I get an Incorrect Argument error:

=COUNTIFS({Review Month}, =1, ISTEXT({Critical 1}))

Where am I wrong here?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!