automated weekly email with dashboard link
Hi All
what I'm trying to do is send out a scheduled (weekly) email, with links to two dashboards for review by everyone that the sheet is shared to.
sound simple enough but i can't get it to work reliably using automation from the main sheet.
have been using the alert someone.
can someone please advise on the best way to achieve this
thanks in anticipation
Andrew
Best Answer
-
Many thanks Andrée Starå
i have got it working I think. Because you can only schedule things to run on the hour i was triggering the email on record change event. Because i was selecting only send email not rows or cells it appeared to impact on the way the email was delivered / what the content was.
it was also compounded by the fact that one of the dashboards is specific to the current user. it's one thing to build these things into a new template but to retro fit them into existing workspaces is a bit of a trial. especially when you(the person developing), isn't a user in the plan. so no data for current user.
I also moved the automation to a summary (roll up), sheet with no active changes on it and this all appears to have worked
many thanks again for your help - i was doing essentially what you suggested
kind regards
Andy
Answers
-
What's not working?
There are three ways to set it up.
- Alert everyone shared to the sheet with the links to the Dashboards included
- Send as Attachment with the links included
Make sense?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Many thanks Andrée Starå
i have got it working I think. Because you can only schedule things to run on the hour i was triggering the email on record change event. Because i was selecting only send email not rows or cells it appeared to impact on the way the email was delivered / what the content was.
it was also compounded by the fact that one of the dashboards is specific to the current user. it's one thing to build these things into a new template but to retro fit them into existing workspaces is a bit of a trial. especially when you(the person developing), isn't a user in the plan. so no data for current user.
I also moved the automation to a summary (roll up), sheet with no active changes on it and this all appears to have worked
many thanks again for your help - i was doing essentially what you suggested
kind regards
Andy
-
Excellent!
You're more than welcome!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi @Andrée Starå - I'm looking to do something similar and would be keen to understand how I would setup option 2.
I would like to Schedule an E-Mail each week with a PDF of the Dashboard attached including a link, is this possible at all?
-
@Andrée Starå I am also trying to do the same thing any way to help?
-
Did this get a response/ resolved? I need the same! :)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives