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

Related Content

Form Rule "Show Report" displays No options

Formula Query with options

Missing an option in Kanban Card Groups

Formula Assistance

Formula Query with custom key