Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Is it possible to constantly check what time it is?

Topic Labels: Dates & Timezones
293 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello! Need some help again😅 and you all were super helpful last time so here we go again!

I have this formula:

DATEADD(DATETIME_PARSE({Meeting End Time},'HH:mm'),{Meeting Length}+15,'minute')

And what I am trying to do is have an email sent out in 15 mins after the meeting has ended. I tried:
IF(NOW()=DATEADD(DATETIME_PARSE({Meeting End Time},‘HH:mm’),{Meeting Length}+15,‘minute’),“YES”,“NO”)

Thus making the cell say yes and automation that reads that cell so if it sees “YES” to send out an email. But the if statement I realize doesn’t constantly check the agreement only when a cell is updated. Does anyone have any ideas on what I should do?

1 Reply 1

The NOW() function updates approximately every 15 minutes (or so) when your base is open, and it updates approximately every 60 minutes (or so) when your base is closed.

So you may want to change your formula to use >= (“greater than or equal to”) instead of = (“equal to”) so that it’s not looking for an exact match on the times, but it’s looking to see if the current time is greater than or equal to 15 minutes since the ending time of the meeting.