How to create an automation that would automatically send an email about expiration?

Topic Labels: Automations
481 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello Everyone, 


Basically I have got a table with documents sign date and expiry date, and created a formula when it shows that the document is "Active" or "Expired" if the date is in the past. 

The question is how to create an automation so whenever formula changes to expired it will send an email telling a person that the document is now expired. 


Hope that makes sense. 



2 Replies 2
6 - Interface Innovator
6 - Interface Innovator

I would use the 'When Record matches conditions' Trigger, and choose your formula field, stating when the record matches 'Expired' to send the email.   

Hmm, what issues did you face attempting to use the "When record matches conditions" trigger?  It seems like if you set it to look for records where the formula field is "Expired", it would trigger as expected, and you could add an email action to it afterwards?

Screenshot 2024-02-08 at 11.10.43 PM.png