Formula Needed

R
Russ Hart 👤 Member for 18 years 7 months
T
Trevor Rabey 👤 Member for 20 years 6 months

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?)

S
Scarllet Pimpernel 👤 Member for 16 years 10 months

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.

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