exclude blank date in At Risk column

Beth Marchand

I need to edit this formula to add in an exclusion of blank dates in the "End Date" column. Suggestions welcome!

=IF(AND(OR(Status@row = "Red", Status@row = "Yellow"), [End Date]@row < TODAY()), 1, 0)

Beth Marchand

Resolved

=IF(AND(OR(Status@row = "Red", Status@row = "Yellow"), [End Date]@row < TODAY(), IF(ISDATE([End Date]162), 1, 0) <> 0), 1, 0)

Beth Marchand

Resolved

=IF(AND(OR(Status@row = "Red", Status@row = "Yellow"), [End Date]@row < TODAY(), IF(ISDATE([End Date]162), 1, 0) <> 0), 1, 0)

Genevieve P.

Hi @Beth Marchand

I'm glad that you were able to solve this! Thanks for providing your solution.

Cheers,

Genevieve