Good Morning All
Wondering if someone could help me add and addition condition to this formula. I tried and keep getting an error back.
I need to add if Program Status Type is NOT blank in the formula below.
If the end date is less, then today and Status @row is not Complete and Program Status Type is not blank then check the flag in the At Risk column.
=IF(AND([End Date]@row < TODAY(), NOT(Status@row = "Complete")), 1, 0)
I am trying to update my Control Center blueprint Project Plan template before I create it in Control Center. Any help would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!