IIf([% complete]=0 and [Start]<[current Date],2,1)
The above forumla works but what i would like to do is have more than a true or false option (2,1 as above)
Basically i'm looking to write a formula that will.....
Put a "1" in a text column if the% complete is greater than 0
Put a "2" in a text column if the task is up to a week late in starting i.e the percent complete has a value of 0 and the date is 5 working days past today's date
Put a "3" in a text column if the task is more than a week late in starting i.e the percent complete has a value of 0 and the date is greater than 5 working days past today's date.
I have not included any way of measuring expectted progress compared to actual progress to date (its a v simple planning we're working in here)
Please help!
Bookmarks