Sending cell information via email from a trigger

Joseph Farahat

Hi,

For reference these assigned are unlicensed.

We use a sheet to assign staff to part time assignments.

We use the automation to send a form once a status field is changed to "can you work".

everything works great ..

Now I cant figure out how to send certain cell information from a row via an email.

Flow would be:

a) status changed to "mail now", triggers the information to be emailed to the assigned person.

b) that person acknowledges receipt of email which response populates another field on the sheet with a "got it"

The fields are already in the sheet.

Cant use an update request because it disappears from the email once acknowledged.

Thank You!!

Andrée Starå

Hi @Joseph Farahat

I hope you're well and safe!

You can use the Placeholder feature.

More info: 

https://help.smartsheet.com/articles/2477796-dynamically-add-cell-data-in-the-subject-and-body-of-request-messages

Would that work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community 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!