Contact group row notifications
Is it possible to email a contact group when updates are made to a specific row?
Michael
Best Answer
-
Thanks for the input, I think this should get the job done.
Answers
-
If you're using Automation, you will need to share the group to your sheet and then select this option in your automation:
I hope this helps.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
I have multiple contacts in each group and I don't want to notify everyone for ever update. I only want to notify a contact group when a cell value meets a certain criteria. For example if cell A1 = 1 "send to group 1" and if A2 = 2 "send to group 2". I was hopeful I could callout the contact group in a cell just like when adding a contact or contacts manually to a "contact list" cell.
-
You could add a condition path that can send to different groups depending on the cell value or something similar.
Make sense?
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
This is what I'm looking for and seems straight forward. I'm not able to alert a contact group however in the automation workflow. See below; MKE Mach Shop which is a shared contact group of the sheet isn't part of the drop down list to select from.
-
Apologies, I should have been more clear.
Unfortunately, it's not possible to send to groups in automation at the moment, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
As a workaround, you can either create different steps in the Workflow or add so-called helper columns in the sheet that would show the contacts depending on which group is selected/needed and then reference that in the Workflow instead. (the contacts would be collected by using a VLOOKUP or INDEX/MATCH in the same sheet or a separate one)
Make sense?
The groups have to be kept up to date for it to work.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks for the input, I think this should get the job done.
-
Excellent!
You're more than welcome!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!