Smartsheet Automated Emails changing custom subject line
Good Morning,
I've have several workflows setup to send out emails that are triggered by dates. I'm using the Alert someone and I have setup specific subject lines in each out these, based on the time frame of a requested completed date.
今天早上,我收到了a "Reminder: Smartsheet Name" email that was sent to all who were required based on the logic used but it summarized two lines instead of the individual emails it should have sent.
Subject line should have read: "Follow up/Escalation for Inquiry#: {{Inquiry #}} Price Implementation Inquiry - {{Customer Level Name}} - {{Inquiry Type}}"
Has anyone run into this before and what did you do to correct it?
Thank you!
Best Answer
-
Katy H ✭✭✭✭✭✭
Totally, unfortunately, dynamic fields in automations only work when one single line of data is being sent. This article details the limitations of working with dynamic fields in automations:
Answers
-
Katy H ✭✭✭✭✭✭
I hope I am understanding you correctly, but if the trigger for your automation is date based, example: send out an automated email every morning at 9 AM, then there is the possibility of more than one line of data getting swept into that automation based on the conditions you have chosen. If you want it to only ever be one line of data the trigger would need to be a change rather than a date.
-
CH42 ✭
Thanks for the response Katy H. That is correct, it is triggered based upon a requested by date. I have an automation to send out on that date it is reached at 7:00am.
Based on your comment and what I'm seeing. It is grouping them together when it is the same "contact" and same date trigger.
Which, ultimately is not a bad thing, but by grouping together, it is changing the subject line of the email and that is the issue.
-
Katy H ✭✭✭✭✭✭
Totally, unfortunately, dynamic fields in automations only work when one single line of data is being sent. This article details the limitations of working with dynamic fields in automations:
-
PDunn ✭✭
@Katy Hall@CH2Katy is referring to when you add a field {{field}} in your subject line. If more than one row meets the criteria it won't list multiple {{Inquiry #}} into your subject line so it changes it to say Reminder. If you remove {{Inquiry #}} from your subject line then your original subject line would appear in the email regardless if there is more than one row that is being affected. Suggestion: change your Subject Line to: Follow up/Escalation for Inquiry - see more details
I've been removing {{Fields}} from my automation notification subject lines to more generic wording. I am then adding the additional fields in the message portion where you select various fields to include in message.
Categories
This method does produce separate reports:<\/p>
The Project Plan report will include this filter: \"Sheet Type\" is one of \"Project Plan\" -- this filter will exclude rows coming from the RAID Log (and all other types of sheets) because those other sheets will have a value in their \"Sheet Type\" column that is not \"Project Plan.\" <\/p>
The RAID Log report will include this filter: \"Sheet Type\" is one of \"RAID Log\" -- this filter will exclude rows coming from the Project Plan (and all other types of sheets) because those other sheets will have a value in their \"Sheet Type\" column that is not \"RAID Log.\" <\/p>
Thus, each report will include a filter rule specifying that only rows with its own sheet type can be included.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"}]},{"discussionID":108417,"type":"question","name":"How do i set up a conditional format, when i want more than one person in the assigned to column","excerpt":"I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that particular assignment, how do i set up conditional formatting for that, or would that be a formula?","snippet":"I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that…","categoryID":321,"dateInserted":"2023-08-02T14:26:40+00:00","dateUpdated":null,"dateLastComment":"2023-08-02T15:27:36+00:00","insertUserID":159629,"insertUser":{"userID":159629,"name":"Genesia","url":"https:\/\/community.smartsheet.com\/profile\/Genesia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T20:20:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":159629,"lastUser":{"userID":159629,"name":"Genesia","url":"https:\/\/community.smartsheet.com\/profile\/Genesia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T20:20:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":25,"score":null,"hot":3381977656,"url":"https:\/\/community.smartsheet.com\/discussion\/108417\/how-do-i-set-up-a-conditional-format-when-i-want-more-than-one-person-in-the-assigned-to-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108417\/how-do-i-set-up-a-conditional-format-when-i-want-more-than-one-person-in-the-assigned-to-column","format":"Rich","tagIDs":[245,254,334,437],"lastPost":{"discussionID":108417,"commentID":388509,"name":"Re: How do i set up a conditional format, when i want more than one person in the assigned to column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388509#Comment_388509","dateInserted":"2023-08-02T15:27:36+00:00","insertUserID":159629,"insertUser":{"userID":159629,"name":"Genesia","url":"https:\/\/community.smartsheet.com\/profile\/Genesia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T20:20:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/9VLKF1G9AO1Q\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-03T09:17:11+00:00","dateAnswered":"2023-08-02T14:42:44+00:00","acceptedAnswers":[{"commentID":388483,"body":"