I would like to send an alert to someone when any field in the row changes, except comments. How can this be done without having to set an alert for each column individually?
Good question. To my knowledge, I don't think there is an exclude criteria. However, instead of setting separate alert workflows for each field, depending on how many columns you have, you can add multiple triggers in the same Alert workflow and set the changes to "Any Value" for each field used in the trigger. Not a optimal solution but if your columns are not too many this can be a workaround.
Add a so-called helper column and a Workflow to check a box or similar to indicate a change in the Attachments, and then add that as a condition in the main Workflow.
✅了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
@SKThank you, I did start doing that, but I do have quite a few columns and there are 4 separate workflows that it would need to be applied to. I also worry about my own human error of not updating the workflows if a new column is added.
@Andree QuirosThank you, I have not created a work flow like that before, but I will look into it.
Both: For more information, this question arose because I have 4 admins updating a sheet, each assigned specific rows for which they are responsible. I added a "modified by" column so that I can alert them if someone, except for themselves, has made an edit to their row so they have full visibility of these items they are owners for without being bombarded with alerts re their own updates. However, the comments do not update the modified by column, so therefore they are receiving alerts about their own comments.
Andrée Starå ✭✭✭✭✭✭
