How to combine formula message based on criteria
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi! This one is a little tricky. The formula tool has an email message includes data from the following columns "Account" and "Reason" for each person. The output below is what I am getting, but I don't want to send 3 emails to the same person. How do I combine so each person has one row and all the Accounts and Reasons are in one email?
Current Output
joe.smith@test.com | Action Needed | Your answers for the following account are invalid:
Account:
Account A
Reason:
Question 1 cannot be blank |
joe.smith@test.com | Action Needed | Your answers for the following account are invalid:
Account:
Account B
Reason:
Question 1 cannot be blank |
joe.smith@test.com | Action Needed | Your answers for the following account are invalid:
Account:
Account C
Reason:
Question 2 cannot be blank |
Desired Output
joe.smith@test.com | Action Needed | Your answers for the following account are invalid:
Account:
Account A Account B Account C
Reason:
Question 1 cannot be blank, Question 2 cannot be blank |
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@richleeb2 Can you provide the input file for this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/6056C79A596CAB15526D64C598622101/responsive_peak/images/icon_anonymous_message.png)