Help

Re: Date formula

178 0
cancel
Showing results for 
Search instead for 
Did you mean: 
itsmeayyub
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a field that includes:

Name
Email
Payment link
Payment_made (checkbox)
Created at (Jan 14)
Send_reminder_1 (checkbox)
Send_reminder_2 (checkbox)

If the payment_made is not "check" even after 3 days.

I want a send_reminder_1 to be auto-check or something with a formula that will say true.

-------

If the payment made is not "check" even after 6 days.

I want a send_reminder_2 to be auto-check or something with a formula that will say true.

-------

How can I do this using formula?

1 Reply 1

Hey @itsmeayyub

In your case you have to use created_time (or the last modified) to cover the condition for the days that have been passed. 

Let's say that you want to track the 3 days since the record created in your base: 

formula in Send_reminder_1

if(AND(
   {Payment_made}=!True,
   DATETIME_DIFF(TODAY(),created_time,"days")>=3
),‌‌,Blank())

formula in Send_reminder_2

 

if(AND(
   {Payment_made}=!True,
   DATETIME_DIFF(TODAY(),created_time,"days")>=6
),‌‌,Blank())​

 

Please keep in mind that you replace the Blank response with an emoji or what works better for you. 

Does it help? 

Yours sincerely,
Dimitris Goudis