Forum Discussion

BrittanyBedore's avatar
BrittanyBedore
Qrew Member
10 months ago

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

Sort By
  • MikeTamoush's avatar
    MikeTamoush
    Qrew Commander
    10 months ago

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