Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Alerts/Notifications with messages
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