I'm working on a sheet with some pretty simple notifications that will alert when a symbol changes to red. I thought I would try using the Run Now feature that (sort of) worked. I say "sort of" since there were issues:
1) My notification should have only alerted on those rows that changed red and notified me as the contact in the Assigned To field. I received a notification on all of my items in the sheet and not just the one that turned red. Why is it showing all of my rows and not the ones that just have the red dot?
2) Turns out everyone on the sheet in the Assigned To field received the notification and they did not have the red dot in any of their rows! Why would everyone have a notification when their rows did not comply with the criteria of needing the red dot?
3) The notification is active and should have sent the alert when it triggered not just when I use the Run Now but I only received the alert when I used Run Now. Why did I not receive an alert just based on it triggering?
Here is my notification:
