late task report | Community
Skip to main content
M
MichelleBo3
Level 4
May 5, 2020
Question

late task report

  • May 5, 2020
  • 1 reply
  • 449 views

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.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity 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

    Terms & ConditionsAccessibility statement

    Loading footer...