Forum Discussion

BrittanyBedore's avatar
Qrew Member
10 months ago

Due date formula based on a checkbox


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" 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. 

Thank you for your help/time!

Brittany Bedore

1 Reply

  • 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