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------------------------------
Original Message:
Sent: 09-15-2022 10:25
From: Catie Bruno
Subject: 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 called "Inspection Required"
Thank you
------------------------------
Catie Bruno
------------------------------