Automated Alert & Action Issues
Hello I am trying to solve an issue with a system I have set up for Automated Alerts & Actions. See screenshots below. As you can see by screenshot 3, I have created a trigger column based on date surpassed; once that date is surpassed the cell will change from N to Y. The idea ultimately is when it changes to Y it triggers an automatic Update Request to the listed "Sales Rep" email as you can see by Screenshot 1. This functionality seems to work, however here is the issue... It sends an emailed Update Request to all the reps listed about all the Rows, so they get inundated with projects that they have no clue of. You can see this creates noise. I just want the Rows assigned to the Rep to go to the Rep. Any Ideas?
Help Article Resources
Check out the Formula Handbook template!