Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Color coding functionality

Topic Labels: Formulas
Solved
Jump to Solution
1397 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Tanzugirl23
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Solution

Accepted Solutions
Tanzugirl23
5 - Automation Enthusiast
5 - Automation Enthusiast

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

See Solution in Thread

2 Replies 2
Andy_Lin1
9 - Sun
9 - Sun

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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