Concatenate USABLE contacts
Hi all,
I have created an FAQs board for my team to share knowledge. They ask a question through a Form, I respond and the requestor gets a direct email with the response. It also stores all the FAQs on a Dashboard for overall team review.
I am looking to send the response not only to the requestor, but the overall team and have a Form for people to request access to those notifications for which I can "approve".
I am now stuck as to how I combine the email addresses or contacts to be able to use as a distribution list "Send to All" which I can reference in the Workflow. I want to reference [Combined List ]1 in the other Grid but it doesn't come across as an email address, just text.
🤨
Thanks
Adam
Answers
-
There is currently no way to do this through formulas.
-
I would suggest you create a user group with all of your users and add that as the recipient to your workflow. For those that don't want to receive the emails they can unsubscribe.
It is possible to create something more dynamic and add/remove users from a column but that would require the API and custom development.
Dan Palenchar | School of Sheets Solutions Consulting (Smartsheet Aligned Gold Partner)
Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
Smartsheet Tutorial Videos: schoolofsheets.com/youtube
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!