Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Sep 29, 2019 02:57 AM
I’m looking for a formula for the following.
I have a Checkbox Field “Msg’d” & Date Field “Date Msg’d” & another Checkbox Field “Responded”
I’m wanting to find a formula where, If “Msg’d” is checked & “Responded is NOT checked” & it’s been more than 3 days after “Date Msg’d” it is marked “FOLLOW UP”
Sep 29, 2019 09:34 AM
IF(AND({Msg'd},NOT({Responded}),DATETIME_DIFF(TODAY(),{Date Msg'd},'days')>3),'FOLLOW UP')