Setting up automatic reminder system

Hello community,

I have a tricky question here concerning how to send out a reminder automatically based on the following idea.

I have a sheet which lists the status of certain rows.

Each row has a column that indicates with Green/Yellow/Red/Gray dots (symbols) - these indicate if an item has been fixed, pending, still broken, or other.

Is it possible to if an item has been marked Yellow(pending) or Red(not fixed) for X amount of days past the original entry - then a reminder will be sent to a specific email address?

I know Kelly Anthony has posted at least two articles concerning similar methods of automating reminders, but was hoping someone in the community could help with this very specific set up I am trying to accomplish.

I appreciate any feedback/questions/comments!

Find more posts tagged with

Calendar View

Formulas

Update Requests

Email Notifications

Comments

Andrée Starå

Hi,

Yes, it is. Unfortunately, I don't have time to give you the details now, but I'll get back in a few days and answer if nobody else has replied with the solution.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

Dave Godfrey

Hi,

I have attached a screenshot of an example of this that i have set up.

I have set up some hidden columns on added the IF formula for it to bring up the the date for the notification to be sent

Here is an example of the formula.

=IF(OR([Purchase Order Reference Number]18 <> "", [Order Acceptance without Purchase Order number.]18 = 1), "", [Date Quote Sent to Client]18 + 30)

Hope this helps

Dave

mwiggins

No problem at all! I really appreciate the speedy response from you (not only on this post but on ones from last week as well).

I have time to experiment some more with IF formulas / doing dates + 'X' days / etc.

Hopefully more people will have solutions.

Sign in to join the conversation!

Quick Links

Trending discussions

Verification of completion of all actions on a sheet
I have a checkbox for 3 separate columns for 3 individuals to check to indicate they have verified an action. The goal is to count the 3 checkboxes if checked and to have one checkbox only for leadership to verify all actions are completed on the entire sheet without having to check every individual task.
Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…