Formatting a "Message Only" Alert
Hello,
I'm trying to figure out what way I can get a "message only" alert in which I can add information from several rows, without the body of the email to duplicate itself. I tried to search the community but I couldn't find an answer to this. I saw one where it was sent to enhancement.
Example:
Hello Name,
<Body of message>
Row 1 Column 1 information
Row 1 Column 2 information
Row 1 Column 3 information
-
Hello Name, (same as above)
<Body of message> (same as above)
Row 2 Column 1 information
Row 2 Column 2 information
Row 2 Column 3 information
I would like it to be something like:
Hello Name,
<Body of message>
Row 1 Column 1 information
Row 1 Column 2 information
Row 2 Column 3 information
Row 2 Column 1 information
Row 2 Column 2 information
Row 2 Column 3 information
or
Row 1 Column 1 information, Column 2, Column 3
Row 2 Column 1 information, Column 2, Column 3
Thanks in advance
Best Answer
-
Hi @ltomasello
It sounds like you're adding placeholders into your custom message in order to surface the row/column information without providing the sheet link.
In this case there is no way to combine the information as you'd like to do above. Each row will be associated with its own message because the information will change per-row, so even though the Name and Body are the same, they will be repeated for every associated row as you've found.
Please let the Product team know about your use-case and feedback by filling in this form, here!
Thanks,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Hi @ltomasello
It sounds like you're adding placeholders into your custom message in order to surface the row/column information without providing the sheet link.
In this case there is no way to combine the information as you'd like to do above. Each row will be associated with its own message because the information will change per-row, so even though the Name and Body are the same, they will be repeated for every associated row as you've found.
Please let the Product team know about your use-case and feedback by filling in this form, here!
Thanks,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Thank you @Genevieve P. Yeah I figured that was the case too. I could have sworn I had seen someone in our company fix this "flaw", but I must of imagined it. Either way, Thank you. I did send a product feedback yesterday. Hopefully they can do something about it. I saw other comments in the community also trying to get some updates to this.
-
Hi @ltomasello
Is it possible that the other user send a message that included specific fields and the sheet link? If you send out fields with the message instead of using {{placeholders}} then it will consolidate the information into one email with a generic message at the top, above the specific details.
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
@Genevieve P. it may possibly have been. I learned about {{placeholders}} from that message but to be honest it was a long time ago and it could have been something that doesn't change like a Contact or maybe the title of the sheet, who knows. I was just hopeful there was a solution for the issue. The current alert will go out with 40+ rows, that will be so bulky no one will read it or even understand it to be honest. We're coming up with workarounds to avoid that issue. Currently the sheet the alert comes out of is private so when the link is present for people to click we constantly get users requesting access to which we have to deny. We're worried to accidentally click ACCEPT and then we would have bigger issues. Thanks again for following up on this 😉
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!