Customized alerts via automated workflows
We have a sheet that we're using as a defect tracker through several UAT phases. This sheet has forms that users can utilize to submit defects that they discover. There's a field in our sheet (DefectID) that automatically populates with the next sequential number as new defects are entered, so that each defect has a unique ID.
We have workflows active on this sheet that will email an alert to a user whenever a defect gets assigned to them.
What we're trying to do is include the DefectID field anywhere in that email alert (either the subject line or the body of the email). This will make it easier for the assignee to sort through their message history about a specific defect in Outlook. Is there a way I can automatically pull that field data into the subject line or message body?
Thank you!
Answers
-
Hi,
I hope you're well and safe!
Yes, you can use the Placeholder feature.More info:
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 comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!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.
-
I think this is what I'm looking for, thank you!
If I'm reading it correctly, I can add the field in the message by adding "{Defect ID}" into the automation? Would that work in both the subject line and the message body? Is there a way I can test the change or see a preview of it before committing the change for everybody?
-
Excellent!
Happy to help!Yes, but it should be {{Defect ID}}, and yes, you can test it before, and I'd recommend making a copy of the workflow and then modifying and testing.
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives