Automated Email based on a Column trigger date

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?

Answers

  • 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.