Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

if is_after 24 hrs

Topic Labels: Dates & Timezones Formulas
788 1
cancel
Showing results for 
Search instead for 
Did you mean: 
dk1988
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"

 

Thanks!!

1 Reply 1
ProsperSpark
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:

------------

IF(
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!  Prosperspark.com