Can I insert "Tiggering User" into alert email Text?

Ray Neave

When creating and automation alert SmartSheet allows you to register the "Triggering User" within the email address of the sender.

However I would prefer all our emails to come from "SmartSheet Automation" but it would be good if the Triggering User name can be included within the body of the alert email text.

Does anyone know if there is a way of inserting the Triggering User name into the email text in a similar manner in which a cell is inserted using {Column Name}?

Michelle Choate 2

Hello @Ray Neave - I would assume using the Modified By column would identify the person that triggered the automation to be sent. Does that work?

Ray Neave

Hi @Michelle Choate 2 ,

Thank you for your suggestion.

The automation that I setup was to inform the originator of the name of the person adding a comment via the conversations function. The sheet includes the "Last Comment" column and a "Comment Date" column which is updated within the automation to send the email to the originator.

When this automation is triggered the "Modified by" column is populated with the text "automation@smartsheet.com" and not the user name, I can understand this as the sheet has been updated by the automation. Curiously I removed the "Comment Date" section of the automation and the "Modified by" was populated as "decision.system@smartsheet.com".

Also I have a Form to populate the sheet and was expecting the "Modified by" column to display the User Name of the person filling in the form. However when the form was used this populated the column with the "automation@" name and using the "Created By" column did not work either as it populated the cell with "web-form@".

At present I do not feel that there is a way to achieve my objective of inserting the Triggering User name into the email text.

Regards,

Ray

Andrée Starå

https://community.smartsheet.com/discussion/136483/can-i-insert-tiggering-user-into-alert-email-text

Hi,

I hope you're well and safe!

Please look at my post below, which contains a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!