Automated Email based on a Column trigger date

Christopher Creamer

I have a workflow that has a column (let's call it Column C) that at some point in production, will have a date. The adjacent column, (let's call it Column D) I am looking to create a filter that auto emails an individual if the date in column C exceeds 14 calendar days from the entered value. How can I do this?

Josh Swendsen

I have something very similar. When renewal time changes to yes it sends an email to the license holder.

Formula used on mine for Renewal time: =IF([Todays Date]@row > [Renewal Date]@row, "YES", "NO")

For Renewal date I put: =[License Expiry]@row - 31

For Todays date: =TODAY()

Hopefully this can help you sort something for your sheet.