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!!
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
