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

Question

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

markshnier__you · Answer

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 · Answer

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 · Answer

npIF([Type] = "Air Monitor", [Serviced/Inspection Date] + Days(90),AdjustYear([Serviced/Inspection Date], 1))------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

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

3 Replies