-
Getting Smartsheet to Take a Snapshot of a Daily Report in Outlook
Hi Everyone! Every morning, I receive an automated email in Outlook with a report that includes different tables. I am creating a Smartsheet dashboard and was wondering if Smartsheet has the capability to take a snapshot (a physical image) of that report each morning and have it appear in my dashboard. Any ideas are…
-
Attend an upcoming Smartsheet Dashboards Webinar!
What if you had everything you needed to visualize your project data, metrics, and KPIs all in one place? Good news — With Smartsheet dashboards, you do! Come learn all about how in an upcoming Dashboards webinar. Register here! What to expect: A comprehensive demo of Smartsheet dashboards. Real-time answers to your…
-
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…
-
Formatting Sheet Summary Reports
Enable formatting in sheet summary reports. E.g changing text size, bolding, colour, move value to centre etc. Currently sheet summary reports look sloppy, requiring time consuming work to add the values as metrics to dashboards if you want them to be presented well.
-
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…
