I need help creating a formula for identifying task status
Options
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.
Tags:
Comments
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!