Formula Needed
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
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?)
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.