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!!
+5HI 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.
