Point Automations to Alternate Smartsheets
I like using daily summary automations rows added or tasks marked complete, but the source file where this is tracked can be confusing. I'm looking for a way to run the automation from the source sheet, but have the email include a link to a report, dashboard, or alternate Smartsheet. I could paste the URL in the message, but that URL would be long and unfriendly.
Best Answer
-
Yes! I just tested this as I was curious if it would work. The full URL works, but so does formatting it as a Hyperlink in the cell:
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Answers
-
The only way is to copy/paste the URL. Feel free to submit a product enhancement request when you have a moment though to let Smartsheet know that you are interested in having this capability. I have seen other users here in the Community also requesting something very similar.
-
There currently isn't a way to hyperlink text in the body of an automated alert message to make it look more friendly; you would need to have the entire URL spelled out in order for it to be a live link. (Please submit your enhancement request to our Product team by filling in this form, here.)
An alternative would be to potentially use a URL shortener like Bit.ly if you wanted the URL to look more friendly. You could also include a helper column in your sheet which contains your Hyperlinked URL behind text, copying this down each row so that the cell will appear as part of the Alert.
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
@Genevieve P So if I include a column in an alert that has a hyperlink in it, the hyperlink will be maintained in the email that gets sent out?
-
Yes! I just tested this as I was curious if it would work. The full URL works, but so does formatting it as a Hyperlink in the cell:
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
@Genevieve P Is it possible to include a Sheet Summary field in the header of an automation message so that the desired URL isn't displayed row by row?
-
No, currently Sheet Summary fields aren't included in sheet Automations, but you can hide the column that houses the URL and it will still appear in the alert.
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
@Genevieve P That's awesome that the hyperlink works! I am definitely going to have to remember that!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
