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?


Tags:

Answers

  • Lucas Rayala
    Lucas Rayala ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!