Date formula | Airtable Community

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?

Page 1 / 1

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

Sign up