I have been waiting for these more advanced notifications for a while now. Thanks for getting this to a much happier place.
I tried creating a generalized "team" notification when any given shared user is assigned a task, I would like them to receive the notificaiton. From what it looks like currently, this is possible, but I would have to create an alert for each person that the sheet is shared with.
What I'm wondering is, can the "Current user" logic from the newest filter changes be applied to notifications as well?
When the "contact column A" is assigned to "Current User", notify the "Current User" "at the set duration".
This functionality would ALMOST make the notifications as good as @Mentioning someone.