Help

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.

Formula for IFCheckbox & IF x # of days

Topic Labels: Formulas
429 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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”

1 Reply 1

IF(AND({Msg'd},NOT({Responded}),DATETIME_DIFF(TODAY(),{Date Msg'd},'days')>3),'FOLLOW UP')