How to update automatic subject line when sending attachments
Hello! Is there a way to automatically change the subject line and contents of the message when sending attachments? When I send attachments from this sheet, I will want all of the subject lines and messages to be the same, but not what Smartsheet automatically populates the form with. Is there a way to change this text so that when I click to send attachments the "proper" text appears without having to type it in every time?
Answers
-
Hi @kmzSAV -- did you still need help with this? Can you clarify this question: are you setting up an automation? If this is an automation and you want to capture text from a column, you can reference specific content using the double brackets, like this {{ColumnName}}.
You can create custom messages in a cell based on a formula, then reference that cell in your heading. For instance, your could create a column called Message with this formula in it:
="Attachment:" + [Attachment Name]@row + "for your review"
Then the subject line could be this:
{{Message}}
Hope this is directionally appropriate!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!