Just Got handed a request from client and am stumped: Have a large Tech Team project plan with ~1000 lines in it that is THE reference plan for changes etc. What client wants is a view/report that shows on a Rolling 3 week window (and Only the tasks due to start / finish in the 3 week window):
Task Task Planned Planned Late? Comments
ID Desc Start Finish
Late? is to be triggered somehow by comparing Today() to Planned Start and if task not started, then return a flag (Red/Bold/LATE showing in view/report in LATE? column)
Comments – Free form field where people can explain LATE? or provide updates
This is driving me nuts, so any help would be GREATLY appreciated, I hate to port this over to Excel, but don’t see options