IF AND formula with multiple arguments
I am trying (very badly) to write the following formula to the Project Status column
- "Ontime" if actual start matches or precedes planned start and planned end is not passed
- "At Risk" if actual start is after planned start and planned end is not passed
- "Late" if planned end date has passed and actual end date is blank
I got this far but don't think I am close.
=IF([Actual Start Date]@row <= ([Planned Start Date]@row), "On Time", IF([Actual Start Date]@row > [Planned Start Date]@row), "At Risk", =IF(TODAY() > [Due Date]1, “Past Due”)
Appreciate any pointers.
Help Article Resources
Check out the Formula Handbook template!