Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Formula for IFCheckbox & IF x # of days

Topic Labels: Formulas
932 1
cancel
Showing results for 
Search instead for 
Did you mean: 
joe_hayes
4 - Data Explorer
4 - Data Explorer

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