How can I notify staff when an assignment in a contact column changes?
I have a sheet set up with a contact column so I can assign staff to a request. This assignment is automatically triggered based on request type. When the staff are assigned to the new row, I set up an automation to notify them via email of the request. This is working well.
However, sometimes the assignment is changed manually depending on workload. When the assignment in the contact column is changed, it is not triggering the notification to the new assignee letting them know they have been assigned. I have a screenshot of my automation. Is there a trick to triggering a notification when the contact row is changed rather than added?
The second automation in the screenshot is what I established to notify staff of a new assignment, and that one is working when the row is first added. I tried adding the top automation to address changes, thinking I could set up a notification for each staff, but that didn't work either. Can anyone see a reason this automation isn't working for changing as assignment?