At Risk Formula
I am trying to put together a formula that flags a project 'at risk' when:
- Deadline is in 3 working days or les from today
- Status is not complete, on hold or canceled
This is what I have - but my challenge is getting trying to incorporate 'workdays' to the formula. I've tried several ways and it is not working.
=IF(OR(Status@row = "On hold", Status@row = "Canceled"), 0, IF(AND([Final Deadline]@row <= TODAY(3), Status@row <> "Complete"), 1, 0))
Thanks for your help!
Help Article Resources
Check out the Formula Handbook template!