How to send reminder/notification 14 days ahead of Due Dates?

I have searched the internet for this answer and have come up short so far in finding an answer.

I am trying to set up notifications to be triggered by creating an Automation rule, formula or combination of both that emails the contact person on the row in the Contact column I created. The desired result is that the person receives notification 14 days prior to the Calibration Due Date as seen in the screenshot. The notification will need to be sent again 7 days in advance of the Calibration Due Date.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!