Clickable Link in Metric Widget on Dashboard
你好!我有a metric widget on a dashboard fills from a cells in a sheet - one call is where we copy & paste an important link into. Currently, the dashboard / widget only displays the text and it is not a clickable link. Is there a way to format the cell, widget, or otherwise to allow this line item to be a clickable link?
Futhermore, we often PDF the dashboard to provide to project teams who do not have smartsheet access - is there a way for the link to also be clickable in the PDF of the dashboard?
Thank you
Screenshot included - the information in the Orange is what I would like to be clickable.
Answers
-
Mike TV ✭✭✭✭✭✭
Metric type widgets allow you to set a Widget Behavior like so:
So as long as it is indeed a Metric Widget, you should be able to change it. For the second problem, when on the dashboard you can go to the File menu and then to Publish and make it so others should be able to get to it. When you turn Read-Only on, you get this window:
-
EJ ✭
Thanks! I would need the link to be what is put into the source document automatically, which will change with each project. Therefore, manually inputting a URL into the widget settings wouldn't quite work for what I'm looking for. However, I realized that if I made the font a little bit smaller, the full URL is visible in the PDF of the dashboard so those users can click on it, which was the greater issue.
For additional context, the link is not a Smartsheet item, but instead a document repository set up specifically for the project in question. Since we (the project management team) have access to the source data sheet of the widget, it's easy enough for us to click the link from there -- but I really wanted our non-Smartsheet user team members to be able to access the link in the PDF of the Dashboard that we provide to them -- so I think I got it resolved for what I need.
Thanks again for your help!
Categories
Have you set predecessors in your project?<\/p>
If not, the actual date change that does not affect the parent level date shows 0 variances at the parent level.<\/p>
😀<\/span><\/p> Hi @Zach Kinser<\/a> <\/p> I hope you're well and safe!<\/p> If you check the Workflow templates, you'll find this one.<\/p> Would that work\/help? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":103697,"type":"question","name":"Row Report, Count Distinct and Summary Formula?","excerpt":"I have a row report that I am building off of a sheet that includes the date, name, and time spent on a task. I am wanting to build a row report grouped by name, that summarizes the sum of the time spent on a task and the count of distinct dates. The part that I am struggling with is counting the distinct dates, as I only…","categoryID":321,"dateInserted":"2023-04-06T15:17:24+00:00","dateUpdated":null,"dateLastComment":"2023-04-06T15:21:28+00:00","insertUserID":149440,"insertUser":{"userID":149440,"name":"OORF","url":"https:\/\/community.smartsheet.com\/profile\/OORF","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-07T19:25:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-04-07T20:57:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":29,"score":null,"hot":3361589332,"url":"https:\/\/community.smartsheet.com\/discussion\/103697\/row-report-count-distinct-and-summary-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103697\/row-report-count-distinct-and-summary-formula","format":"Rich","tagIDs":[254,265],"lastPost":{"discussionID":103697,"commentID":370654,"name":"Re: Row Report, Count Distinct and Summary Formula?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/370654#Comment_370654","dateInserted":"2023-04-06T15:21:28+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-04-07T20:57:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/QTOYB8CVWJ5Q\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-06T15:24:41+00:00","dateAnswered":"2023-04-06T15:21:28+00:00","acceptedAnswers":[{"commentID":370654,"body":" To get the summary value, you would need to create a sub-grouping in the report.<\/p> You will not be able to perform additional calculations off of this data within the report though. You would need to create a separate sheet and use formulas with cross sheet references looking at the actual source data (not the report) to get that average.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">![\"baseline](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/K4IDVIIXT9OO\/baseline-with-indented-rows.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/p>
<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":103698,"type":"question","name":"Automation trigger on row deletion","excerpt":"How do you trigger a automation when a row has been deleted? I found a older post from 2020 with instructions but those seem outdated now as well.","categoryID":321,"dateInserted":"2023-04-06T15:32:08+00:00","dateUpdated":null,"dateLastComment":"2023-04-06T16:04:35+00:00","insertUserID":149520,"insertUser":{"userID":149520,"name":"Zach Kinser","url":"https:\/\/community.smartsheet.com\/profile\/Zach%20Kinser","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-06T16:21:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-04-09T07:07:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":19,"score":null,"hot":3361592803,"url":"https:\/\/community.smartsheet.com\/discussion\/103698\/automation-trigger-on-row-deletion","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103698\/automation-trigger-on-row-deletion","format":"Rich","lastPost":{"discussionID":103698,"commentID":370674,"name":"Re: Automation trigger on row deletion","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/370674#Comment_370674","dateInserted":"2023-04-06T16:04:35+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-04-09T07:07:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-06T16:23:41+00:00","dateAnswered":"2023-04-06T16:04:35+00:00","acceptedAnswers":[{"commentID":370674,"body":"![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/8WOC7DFK5B60\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/p>
