I need help creating a formula for identifying task status

PDS

Here is the formula I'm using...

=IF([End Date]56 > TODAY() + 7, "Future Task", IF(AND([End Date]56 < TODAY() + 7, [End Date]56 > TODAY(), [% Complete]56 < 1), "On Schedule", IF(AND([End Date]56 < TODAY(), [% Complete]56 < 1), "Late", "Complete")))

The formula works to identify Future and Late tasks.  How do I update the formula to accurately identify On Schedule tasks based on % complete and End date?  In some instances, the formula returns complete for a 0% complete task that should be identified as a Future Task.

 

Please help. 

 

Nic Larsen

Try this: 

=IF([% Complete]@row = 1, "Complete", IF([End Date]@row > TODAY() + 7, "Future Task", IF(AND([End Date]@row < TODAY(), [% Complete]@row < 1), "Late", "On Schedule")))

PDS

Got it.  Thanks.