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.
Alert based on Report, not Sheet?
Is there a way to set up an alert based on changes to a report instead of a sheet? I have a "master" sheet that constantly grows on a daily basis and several reports for different departments to display the information that is relevent to only their department. If I set up an alert for the sheet then the department leads are notified on all new updates to the sheet, not just their department. I tried to create check box columns for each department, include an if statment [=IF(Department="A", 1, 0)], for the check boxes and then set up an alert based on that column. However this doesn't solve the problem because an alert still sends because the checkbox column changes either way as it is added to the bottom of the report by a form.
Also because the "master" sheet is so large, 500+ lines I prefer the department leads to work solely in the reports, but the alert email from the sheet obviously only has the link to the sheet.
Any assistance in this would be greatly apperciated!!