exclude blank date in At Risk column

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)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!