Formula between dates

[itsmeayyub]

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?

[Dimitris_Goudis]

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