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.
Hi @Hannah Bergh
I hope you're well and safe!
Unfortunately, it's not possible now, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
Here's a possible workaround or workarounds
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking 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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
@SK Thank 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 Quiros Thank 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.
©2022. All Rights Reserved Smartsheet Inc.