How to remove the trigger language in the email sent via Smartsheet Automation

Hello,

I have an automation that I want to run after a form is submitted with an output that is generated by the form answers. In testing it, I would like to be able to remove the "1 row added" and the yellow color in the email body (see the blue arrows).

Is there a way to remove this? It doesn't appear in my automation that runs on a date/time schedule, but this workflow I need to run immediate on the completion of the form.


Best Answer

  • Itai Perez
    Itai Perez ✭✭✭✭✭✭
    Answer ✓

    Hey @Danielle O'Connell

    I think I understand now, maybe think about only sending a comment without sending the row so then you can add the data into the comment using {{}} from the columns you would like.

    This way there will not be a mention of rows and also there wont be a table because you will only send the comment.

    Could that work?

    Itai Perez

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez/

Answers

  • Itai Perez
    Itai Perez ✭✭✭✭✭✭

    Hey @Danielle O'Connell

    Can you share the automation you are using? a screenshot would be best.

    Itai Perez

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez/

  • Danielle O'Connell
    Danielle O'Connell ✭✭✭✭✭

    @Itai please see below:

    The desired function is as follows:

    1. User fills out the questions on the form
    2. The answers populate in Smartsheet and a column with a formula calculates a score/result based on answers
    3. An email is sent to the user with the score and directions on next steps


    As noted above, when I have the trigger sent to send for dates the appearance of the email is more professional (no yellow, no mention of rows being added, etc.). I would like to avoid having to set up an automation that runs every 5 minutes and use and 'Updated' date/time column to signify if an email should be sent just to get the formatting of the email I'm looking for.

    Screenshot of current automation:


  • Itai Perez
    Itai Perez ✭✭✭✭✭✭
    Answer ✓

    Hey @Danielle O'Connell

    I think I understand now, maybe think about only sending a comment without sending the row so then you can add the data into the comment using {{}} from the columns you would like.

    This way there will not be a mention of rows and also there wont be a table because you will only send the comment.

    Could that work?

    Itai Perez

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez/

  • Danielle O'Connell
    Danielle O'Connell ✭✭✭✭✭

    Thanks @Itai that does work and is probably the best solution without Smartsheet providing additional functionality in modifying workflow emails. I appreciate the solution!