Help

if is_after 24 hrs

Topic Labels: Dates & Timezones Formulas
690 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