-
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…
-
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…
-
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…
-
Dashboard widget layering
Hello I want to add a map (image widget) on my dashboard then use either a metric or text widget to layer on top of my image widget. Is this an option. Is there another work around? For example i have a map of Australia i want to add to our dashboard, then i want to use text box widget to point out areas in Australia. If…
-
Text wrapping for chart axis labels
I would love the ability to turn on text wrapping for chart axis labels in a dashboard. Smartsheet automatically tilts my longer labels in a diagonal style which is difficult for our company leadership to read/follow and makes the bottom of the widget so much longer, taking up a lot a valuable real estate in a dashboard.…
-
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…
-
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…
-
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…