Skip to main content
Question

Formula: If certain option is picked in the field then add 90 days to the date

  • September 15, 2022
  • 0 replies
  • 56 views
Forum|alt.badge.img+6

Hello,
Can I get help with the below formula?
If the field called "type" shows "Air Monitor" then add 90 days to the "Serviced/Inspection Date".
I want the +90 days date to show up in a new field called "Inspection Required"
Thank you

------------------------------

------------------------------

    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    Try this as a formula date field called Inspection Required.

    IF([Type] = "Air Monitor", [Serviced/Inspection Date] + Days(90))

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement