Formatting a "Message Only" Alert

Options

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

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    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

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    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

  • ltomasello
    ltomasello ✭✭
    edited 11/18/21
    Options

    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.

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    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.

  • ltomasello
    Options

    @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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!