Due date formula based on a checkbox

Question

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.&nbsp;
So, basically...If the "Calibration Complete" box is checked, and the "Calibration Due Date" is prior to or on Today then it displays the number of days overdue.
I am fairly new to QuickBase and struggling to figure out how to formulate that.&nbsp;

Thank you for your help/time!

------------------------------Brittany Bedore------------------------------

miketamoush · Answer

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]&lt;=Today(), $Overdue)------------------------------Mike Tamoush------------------------------

Forum Discussion

Due date formula based on a checkbox