Logic Project Plan
Need a help on the project plan logic related to Sch Health.
The logic i am using on the schedule Health is not showing me the correct result.
As you can see Start date is 06/01 and End Date is 06/30 the % Complete is 50% ideally it should be green because it just a week and the % complete is 50%
Can any one help on the formula ..I am new so I have not much Idea how can I make this formula as per the above infomation.
=IF(Status@row = "In Progress", "Red", IF(Status@row = "Complete", "Green", IF(Status@row = "Not Started", "Gray", IF(Status@row = "On Hold", "Yellow", ""))))
Help Article Resources
Check out the Formula Handbook template!