Automation for expiring dates

Hello,

I'm trying to create an automation for a coloum of expiring dates. Each row is associated with a different email, so when the date for their insurance is expiring in two week I would like to sent out an automatic notification to that email address associated with that row. Is this possible?

Find more posts tagged with

Solution Center

Conditional Formatting

Email Notifications

Comments

Andrée Starå

Hi Jesse,

Yes, it is. I'll get back to the post with how soon.

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andrée Starå

Here's a screenshot of the setup.

Hope that helps and let me know if you have any questions!

Screenshot of Google Chrome (2019-09-26, 20-50-05).png

Scott Willeke

Please reply and confirm that this works for you. If not let, let us help us understand why and we'll try to help.

Sign in to join the conversation!

Quick Links

Trending discussions

How to prevent or recover deletion of rows
Is it possible to prevent the deletion of rows in a sheet? Specifically, in cases where a user legitimately requires editor permission to the underlying sheet and where the row cannot be locked (as continued editting of the row is required.) If not, what are some strategies for recovering a row that has been inadvertently…
Dashboard Adding Widgets Spontaneously
Howdy, I am working on developing a several dashboards for our team, and for whatever reason the widgets I place are multiplying. I have copied/pasted some, but other I have just added I am ending up with dashboards that look like this: When originally I only had the top four items. It has happened on several different…
Project Management with tracking costs
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…