-
Getting Outlook to Open After Clicking Email Hyperlink in Dashboard
Hello! I am making a dashboard and am using a Rich Text Widget to include relevant contact email addresses. All of the emails I included appear as hyperlinks in the Dashboard and the actual links include "mailto:" followed by the intended email address. The formatting is correct, however when I click on the hyperlinks…
-
Did Dynamic View links change recently? Broken web content widgets on Dashboard...
We just discovered a dashboard that had every web content widget with a 404 error. We noticed that the links have changed. When we switched to the new link, the widgets work again. Old/Broken Link: https://dynamicview.smartsheet.com/views/[UUID] New/Working Link: https://app.smartsheet.com/dynamicview/views/[UUID] Note…
-
Formula not returning the correct values
I'm having a bit of a weird issue. I have a helper column that is supposed to return values that are pulled for a metrics sheet. Overall the formula is working, but it's like its not moving past the "Materials Delivered to Vendor" part. =IF([GM Status]@row = "PO Created", "Written", IF([GM Status]@row = "Delivered to…
-
Modify the Header/Document Name on a Published Dashboard
When publishing a dashboard, the dashboard name automatically appears in the top left banner of the web-version. Sometimes, the name of the file is confusing or not appropriate for the public audience. This is common when I have an "internal view" and an "external view" of the same dashboard. I would like to be able to…
-
Seeking Assistance with Smartsheet for Task Management
Hi all, I’m very new to Smartsheet and am keen to explore its features with the goal of eventually rolling it out in my work area. I have an enterprise license assigned through the Government. In our area—Media and Corporate Communications—we receive many tasks through Microsoft Outlook. These often include requests for…
-
How do I gather and display info for this dashboard widget?
Hello Everyone! I have a dashboard that is tracking the progress of several projects. My audience had requested a visual representation of where each project is in the PM Phases Initiation, Planning, Execution, Monitor and Control, Closure I have created a sheet summary report that shows in words where each is is but they…
-
How can I add a widget to show overall project health, pulling data from a Master Timeline?
Hello, I am trying to add a widget to my dashboard to show the overall Health of a project. I already have a health column in the sheet I will be referencing, and I have added a chart to the dashboard showing the individual tasks and their Health, but I want to add a widget (please see below what I am looking for) based on…
-
How can I create a chart on the dashboard with multiple lines showing trends?
I have a sheet below that will be updated every month. The goal is to see trends throughout the month. There will be separate charts for the last 2 columns (Claims and $ Value). What my thinking is having Month on the Horizontal Axis and Claims or $ Value on the Vertical Axis. There will be 22 lines, each representing a…
-
Getting a total to Show up in a Chart Dashboard
Is it possible to get the total of a sheet report (summed up for a total) to show up in a chart widget for a dashboard. Below is the total from the sheet summary along with the current chart on dashboard
-
Templated Sheets and Dashboards
Hello! I have been trying to do some research into this and all of the previous questioned posted were all from some time ago (3,4 years!) so I wanted to revisit the question. I am working on a means to create a templated sheet that is automatically tied to a dashboard that does not require someone to manually switch the…