G
Gene Clifford
Greetings - I am trying to set-up a red/green indicator in
Project Center to show if the plan has been updated within
the last 5 days (Red if no, Green if yes). I know I can
just look at the 'Last Modified' date, but my execs would
like a 'quick look'. I have used the following formula in
an Enterprise Project Number field, but I am not getting
consistent results:
IIf((ProjDateDiff([Last Update],[Current
Date])/60)/8>5,1,2)
I have projects that haven't been modified in over 5 days
that are green, have been modified that are red, etc.
Any help would be greatly appreciated!!!
Project Center to show if the plan has been updated within
the last 5 days (Red if no, Green if yes). I know I can
just look at the 'Last Modified' date, but my execs would
like a 'quick look'. I have used the following formula in
an Enterprise Project Number field, but I am not getting
consistent results:
IIf((ProjDateDiff([Last Update],[Current
Date])/60)/8>5,1,2)
I have projects that haven't been modified in over 5 days
that are green, have been modified that are red, etc.
Any help would be greatly appreciated!!!