Count rows based on Date and Value criteria

Scott Peloquin

Hi,

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.

Michael Pappas

If you want to use the ISDATE function, then (according to this https://community.smartsheet.com/discussion/35316/countifs-problems#comment-114691) your formula should be =COUNTIFS(Rating:Rating, "High", [Date Initiated]:[Date Initiated], ISDATE(@cell)).

Alternatively, you could just look for not-blanks in your Date Initiated column like this: =COUNTIFS(Rating:Rating, "High", [Date Initiated]:[Date Initiated], <>"").

Scott Peloquin

I tried both and and all I get is #Invalid Operation. The date column is formatted as a date type but the Risk column is a formula to display high, medium, or low based off a calculated value in another column. The Risk column is not a singe select data type. Not sure if that's what is throwing this off.