Skip to main content

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”

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


Reply