- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 13, 2023 09:49 AM - edited ‎Dec 13, 2023 09:50 AM
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!!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 16, 2023 01:49 PM
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
