Microsoft Project Member for 19 years 11 months Member for 19 years 11 months Submitted by Trevor Rabey on Wed, 2010-01-20 07:16 Permalink RE: Formula Needed 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?) Member for 16 years 3 months Member for 16 years 3 months Submitted by Scarllet Pimpernel on Wed, 2010-01-20 04:55 Permalink RE: Formula Needed 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. Log in or register to post comments
Member for 19 years 11 months Member for 19 years 11 months Submitted by Trevor Rabey on Wed, 2010-01-20 07:16 Permalink RE: Formula Needed 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?)
Member for 16 years 3 months Member for 16 years 3 months Submitted by Scarllet Pimpernel on Wed, 2010-01-20 04:55 Permalink RE: Formula Needed 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.
Member for
19 years 11 monthsRE: Formula Needed
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?)
Member for
16 years 3 monthsRE: Formula Needed
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.