Help

Re: If Due Date is Today, Enter X in Field

Solved
Jump to Solution
2521 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Robbi_Behr
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m trying to set up an automation that will send an email reminder at a later date to complete a task.

I have set up one column with “Due Date” another as “Today” and a third as “Send”.

I have set up the following formula that when “Due Date” = “Today” it should put an “X” in the “Send” column. My automation is set to send the email when the “Send” field is updated with an X in it. Here is the formula:
IF({Due Date} = {Today},“X”)

It did not work. I also tried:
IF(IS_SAME({Due Date},TODAY()),“X”)

That didn’t work either. Just to test it, I tried:
IF(IS_SAME({Due Date},TODAY()),“X”,“Y”)
and then all the columns filled with Y, even the one where the Due Date matched Today.

???
Screen Shot 2022-06-18 at 11.33.44 PM

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

IF({Due Date} = Today(),"X")

This formula will work. If not, it’s probably a time zone issue. Airtable sees dates as midnight in the GMT time zone, unless otherwise specified.

See Solution in Thread

3 Replies 3

Hi Robbi, that’s super interesting. I’ve created what I think is the exact same setup here and it seems to work just fine

Screenshot 2022-06-19 at 1.33.13 PM

DM me a link to your base and I can see whether I can figure it out for you

ScottWorld
18 - Pluto
18 - Pluto

IF({Due Date} = Today(),"X")

This formula will work. If not, it’s probably a time zone issue. Airtable sees dates as midnight in the GMT time zone, unless otherwise specified.

Robbi_Behr
5 - Automation Enthusiast
5 - Automation Enthusiast

It was a time zone issue! I had been working on it at night in the EST time zone so the days didn’t match up because the time zone toggles weren’t switched, so it was tonight in the Date field and tomorrow in the Today field. :crazy_face:
It’s working now, thank you!