Color coding functionality

[Tanzugirl23]

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?

[Andy_Lin1]

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, "❗")

[Tanzugirl23 · Accepted solution]

Your response was very helpful. I used the conditions option to color-code my renewal dates.  Thank you!