Rich Text Formatting in email notifications (and Update Requests)

Hyperlink cannot be included in a customized message in the Workflow. I am using Smartsheet to have people register for a simulcast. The workflow includes a message sent to the registrant but I am unable to have hyperlinks to calendar downloads included in the message.

Here is a workaround, at least for bold text: Usehttps://boldtext.io/to convert plain text into Unicode. Type in what you want to convert in the top part, then copy the converted text from the bottom part, and use those unicode-converted values to identify columns in email alerts that are otherwise plain text.

Examples: ,

These are not formatted text, they are actually different characters altogether; if you copy-paste those into your sheet or alert, you should see them come through as looking like formatted text.

To provide field names in notifications, we use an "aggregator" column to group multiple columns into a single field, so you simply reference the Aggregator column instead of maintaining formatted column names in each notification (assuming you have more than one that goes out to people).

Assuming that your column names are Idea Title, Description, Status, Comments from PMO, and Submission date, the Status Aggregator column (column formula) would look like this: =(" : " + [Idea Title]@row + CHAR(10) + ": " + [Description]@row + CHAR(10) + ": " + [Status]@row + CHAR(10) + " : " + [Comments from PMO]@row + CHAR(10) + " : " + [Submission Date]@row + CHAR(10))

So your message would look something like this:

"Hi [Name],

Thank you for sharing your idea with us, the status of your request is below:

{{Status Aggregator}}"

That way you can maintain message contents in a single field without needing to go to your Automations if you want to make changes to the columns that are being presented to people.

You can, of course maintain those individually, so if you wanted to do that you would just put this in your notification messages:

: {{Idea Title}}

:{{描述}}

...etc.

You could run into issues if you have people using email clients that do not support Unicode; as unlikely as that may be nowadays, if that is an issue, people could just see rectangles or blank spaces instead of letters for the "formatted" text.

目前,没有办法粗体或斜体the email messages that go out as part of automations. Having the ability to change text color, highlight, and bold would be incredibly helpful for user adoption and to distinguish SmartSheet from competitors.