Re: if is_after 24 hrs

246 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

hey there,

how would i go about creating a formula column where if a timestamp from a column (let's call that column "timestamp") is older than 24 hrs, then the resulting value would be "follow up", otherwise the resulting value would be "do not follow up"



1 Reply 1
5 - Automation Enthusiast
5 - Automation Enthusiast

HI DK1988,

Yes! This is certainly possible. 

In Airtable, you can use the IF function along with NOW() and DATETIME_DIFF functions to achieve this. Here's a formula that you can use in a new formula column:


DATETIME_DIFF(NOW(), {timestamp}, 'hours') > 24,
'follow up',
'do not follow up'


This formula compares the difference in hours between the current time (NOW()) and the timestamp in the {timestamp} column. If the difference is greater than 24 hours, it returns 'follow up'; otherwise, it returns 'do not follow up'.

This should do the trick!  Good luck and please reach out if there is anything else we can help with!