Skip to content
ProjectControls.com
Microsoft Project

Formula Needed

In the Open Standard
Russ HartMember for 18 years 11 months
Created
2
3
0
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.

Cheers,

Russ.
Save Follow Follow forum Report
Reply New topic

2 replies

Oldest first
  1. 0
    Scarllet Pimpernel ·
    #1
    Hi,

    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,
    Scarlett.
    Report
  2. 0
    Trevor Rabey ·
    #2
    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?)
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?