Customized alerts via automated workflows

Options

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!

Tags:

Answers