Forum Discussion

HunterB's avatar
HunterB
Qrew Cadet
3 years ago

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

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 ...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
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
------------------------------
HunterB's avatar
HunterB
Qrew Cadet
3 years ago

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?


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

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    np
    IF(
    [Type] = "Air Monitor", [Serviced/Inspection Date] + Days(90),
    AdjustYear([Serviced/Inspection Date], 1))


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