I have a sheet that tracks employees certifications. I'd like to setup a single automation that runs weekly to alert the employee when the expiration date is within 180, 90, 60 and 30 days away. I'd prefer that the 180 day alert only be sent monthly until the 90 day date is hit, then weekly. I'd like the message sent to reflect the time left before the certification expires or at least the 180, 90, 60 or 30 day range.

I have a basic automation built that is working but it's triggering in the appropriate date ranges or triggering for all of them.