Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Formula Needed

2 replies [Last post]
Russ Hart
User offline. Last seen 7 years 2 weeks ago. Offline
Joined: 8 Nov 2007
Posts: 8
Groups: None
I need a formula to show when the "Start" is later than the "Status Date" AND the "% Complete" equals 0...

I will apply this to a fag so that the "yes" result is returned thus showing overdue starts.

I’ve tried a few but can’t seem to get it working.




Trevor Rabey
User offline. Last seen 1 year 1 week ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
No need to use EXCEL.
Tried anything like this yet?

IIF([start]>[Status Date] AND [% Complete] = 0,yes,no)

(not tested)

but this only unstarted tasks in the future relative to the status date, not "overdue starts" (what are they?)
Scarllet Pimpernel
User offline. Last seen 12 years 21 weeks ago. Offline
Joined: 19 Jul 2009
Posts: 152

You can export to excel and have it link.

from excel, it is very easy to use conditional formula with matching color codes to highlights the extreme overdue and hopefully you will be ablt to get what you want.

Thank you,