Skip to main content
Question

Due date formula based on a checkbox

  • July 31, 2023
  • 0 replies
  • 59 views

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
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+20
    • MikeTamoush
    • Registered
    • July 31, 2023

    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
    ------------------------------
    Terms & ConditionsAccessibility statement