Hello! Is there a way to create a notification (using the color function) highlighting an expiration date in my Airtable to alert me five months before an asset expires?
Page 1 / 1
You can colour code records based on the condition
"Where {Expiration Date} [is on or before] [number of days from now] '150' "
Alternatively, you can set up an email automation using the trigger "When a record matches conditions" with the condition above.
If you want it to be part of a record, you can set up a formula field with the formula (you can use anything to represent it, I just picked the red exclamation mark emoji).
IF(DATETIME_DIFF({Expiration Date}, TODAY() , "M") < 6, "❗")
Your response was very helpful. I used the conditions option to color-code my renewal dates. Thank you!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.