We are tracking a bunch of different tasks in QB and are wanting to start a countdown timer when a task is changed. How I would like to do this is as follows:
Once a task is put into the system it would take the [Task Creation Date] and start a countdown 24 hours from that date/time.
Once task [Status] is changed to "assigned" i would like to start a countdown timer for 48 hours or 120 hours depending on if a check boxes is checked
If the countdown timer ever gets to 0 i would like to flag the task at Late by checking a checkbox named [LATE]
Any help would be greatly appriciated.