late task report | Adobe Higher Education
Skip to main content
Level 4
May 5, 2020
Vraag

late task report

  • May 5, 2020
  • 1 reactie
  • 449 Bekeken

i am trying to run a report that will show tasks late after 5 min past planned start time. i got the late part but can't get the plus 5 min part.

Er kunnen geen reacties meer worden geplaatst op dit onderwerp.

1 reactie

Doug_Den_Hoed_AtAppStore
Community Advisor
Community Advisor
May 5, 2020

Hi Michelle,

One approach I've used is to create a calculated date parameter (e.g. "Five Minute Cutoff") on the tasks that adds five minutes to the planned completion date using ADDDAYS(Planned Completion Date,(5/(24*60))), then filtering (and or conditionally formatting) for those tasks that are not yet complete and whose Five Minute Cutoff is < $$NOW.

Regards,

Doug