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

Find more posts tagged with

Dashboards

Accepted answers

Andy Counsell

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

All comments

Andrée Starå

Hi @Andy Counsell

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!

Andy Counsell

Many thanks Andrée Starå

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

Andrée Starå

@Andy Counsell

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!

Marc Crossfield

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?

Teagan

https://community.smartsheet.com/discussion/comment/334526#Comment_334526

@Andrée Starå I am also trying to do the same thing any way to help?

Katie321

https://community.smartsheet.com/discussion/comment/334526#Comment_334526

Did this get a response/ resolved? I need the same! :)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.