Forum Discussion

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

Qrew Legend

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

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