Count rows based on Date and Value criteria


I'm trying to count the rows in a sheet that have two criteria. I'm using the formula in a Sheet Summary field. The Date Initiated column cannot be blank and the Risk column is at High. Here is the formula I've tried with some variation:

=COUNTIFS(Rating:Rating, "High", [Date Initiated]:[Date Initiated], ISDATE@row)

All I get back are normal formula errors.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!