First post and new to MS Project, so please bear with me if I forget some minor details.
My question is this: Is it possible to setup an indicator column in MS Project that displays a multi-tiered overdue/coming-due indicator?
If a task is overdue, we see a red indicator
If a task is 2 weeks from due date, orange
If a task is due this week, yellow indicator
If a task is over 2 weeks out and incomplete, a green indicator.
If a task is completed regardless of due date, we will see a blue indicator(or smiley face).
I have found several formulas and macros that do something similar or a portion of this, but none that are able to dissect the dates with such accuracy.
If anyone is capable of providing some insight on this it would be greatly appreciated. Please do not hesitate to let me know if you need any additional information.