Formula Needed

R
Russ Hart 👤 Member for 18 years 8 months
T
Trevor Rabey 👤 Member for 20 years 8 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 17 years

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.

Featured Partner

Top Posters

jeoffrey reyes
15 posts
Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts