Discussions

 View Only
  • 1.  Formula: If certain option is picked in the field then add 90 days to the date

    Posted 09-15-2022 10:26
    Edited by Hunter B 11-22-2023 09:41

    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

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

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



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

    Posted 09-15-2022 10:30
    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
    ------------------------------



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

    Posted 09-15-2022 10:32
    Edited by Hunter B 11-22-2023 09:41

    Thank you how would it look if I want it say add 1 year for all options except air monitor if air monitor then 90 days?


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



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

    Posted 09-15-2022 10:36
    np
    IF(
    [Type] = "Air Monitor", [Serviced/Inspection Date] + Days(90),
    AdjustYear([Serviced/Inspection Date], 1))


    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------