Alerts/Notifications with messages

Irene Plant

I have a sheet named inspection sheet, on this sheet is several inspections that are due at different times of the week, month and year. In order to make sure these inspections are carried out I have listed the inspections in rows, on each row is the date it is due and the person it is assigned to. Therefore to ensure these inspections are carried out on time I have set up a 'blanket alert' to email the 'assigned to' on 'due date'. This works okay in that people are receiving emails to tell them an inspection is due. The only problem is they are then having to go into the sheet and find which inspection is due, what i would like to do is get a more specific alert sent out for each of the inspections. I know I could do this by setting up an alert on each row but there are literally hundreds of inspections and this would take forever! Does anyone know if there is a way to do a 'blanket alert' as I have done already but to inculde the name of the inspection so the alert would just have to pick up 'Inspection Name'. Hope that makes sense?! Any help would be appreciated. irene

J. Craig Williams

Irene,

rI don't have an example of a Reminder in my email at the moment ... I thought it referenced the row that triggered the reminder.

 

You could try something like is discussed in this blog post:

 

https://www.smartsheet.com/blog/support-tip-conditional-reminders

 

Or if your Reminders are always on "Due Date", you could have a report that lists non-completed inspections from the last week or so. The users could have the report as a favorite to get to the list quickly. 

 

Work flow would be something like:

1. user gets email that an inspection assigned to them is due

2. user opens report to see what inspections are due or past due

3. user updates info from report.

 

Hope this helps.

I might have more suggestions after I see the Reminder email again.

 

Craig