Help

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

Re: Formula for IFCheckbox & IF x # of days

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