Due date formula based on a checkbox
Hello,
I am looking to create a formula that shows how many days an item is overdue for calibration using a completed checkbox and a due date field.
So, basically...If the "Calibration Complete"...
Forum Discussion
Try this:
Make a Formula Duration Field with the following:
var duration Overdue = Today()-[Calibration Due Date];
If([Calibration Complete Box]=true and [Calibration Due Date]<=Today(), $Overdue)
------------------------------
Mike Tamoush
------------------------------