Setting At Risk, but need to exclude specific status'

Brent.Taylor

I'm currently using a formula I found from a member and it works great. Below:

=IF([Finish]@row<= TODAY(-4), "Red", IF([Finish]@row<= TODAY(-2), "Yellow", "Green"))

I need to exclude this if "Status" is "Complete" or "N/A"

Thanks!

Brent

Nic Larsen

Try: =IF(OR(Status@row = "Complete", Status@row = "N/A"), "", IF(Finish@row <= TODAY(-4), "Red", IF(Finish@row <= TODAY(-2), "Yellow", "Green")))

Nic Larsen

Try: =IF(OR(Status@row = "Complete", Status@row = "N/A"), "", IF(Finish@row <= TODAY(-4), "Red", IF(Finish@row <= TODAY(-2), "Yellow", "Green")))

Brent.Taylor

Nic, That worked great!

Thanks so much for your help!

Brent