-
Metrics Widget - Summarize from Many Sheets in a Workspace
I want to add a Metric widget to a Dashboard that totals the number of projects that I have in another workspace. Each schedule (sheet) in that workspace has standard summary fields that I use in Reporting. When a new schedule is dropped into the workspace, it is automatically picked up by all the reports that look at that…
-
Multiple Checkbox's for sheet summary into a dashboard.
Good afternoon, I am looking to see if this is possible. I am looking to have a dashboard automatically populate with a new row when another is "complete". Which I am able to accomplish with automation tasks. The issue is building the dashboard that has multiple columns of checkbox's. Please see the photos below for an…
-
Embedding a powerpoint in a dashboard
The instructions for embedding a pptx in a dashboard look straightforward. I've opened my pptx on the web and copied the embed link, but when I paste it into the Web Content Widget, I get the error "We couldn't find any embeddable content from this link. Please check the link and try again." I'm following all the…
-
Formula for Status Summary Report and Project Task Completion
Hi Smartsheet Team, I have the following charts. Left one, I retrieve the data from Status Summary Report. On the right side, I have the formula to calculate the Project task completion. However, you will see the complete % is different between these 2. My "Not Started" in Sheet Summary formula is =COUNTIFS([Count of…
-
How to fix "Smartsheet app only" displaying in Published Dashboard
Hello All, I want to share a dashboard I've created with my department. However, when I view the published version of it, I get one of these displaying for one of my reports: Can you help?
-
Project Task Completion - Complete and Remaining Pie Chart
Hi Smartsheet Team, a. Can you tell me how I can make the following Project Task Completion chart? In the Smartsheet, what column or tasks do I have to select to make this chart? I also want to ask if I post something here but then I find the solution and want to cancel my post. Do you know where I can delete the post?
-
Info box on a dashboard
I would like to place an explanatory field (black box) on a dashboard, which is activated only by a "mouse over" over an infofield (i) (see screenshot example). Does smartsheet provide this functionality? Thanks for any hints.
-
Stacked column for two dimensional view, combining 2 groups in one column
We would like to be able to see in one stacked column/bar the combination of two data groupings... ex first category group (=name column) with as subgroup phase mentioning for the items in this category (stacked items in the column by category). Currently not possible to see this in the chart widgets. Solution offered is…
-
Real-Time Timeline Chart
Hi Everyone, Did anyone try to create a real-time timeline of the project status on the dashboard? - not necessary this template but any to track project completion status Thanks,
-
Where can I find my reports?
Hi Smartsheet Teams, I made 2 reports and put those in a folder - Social Media Summit. When I want to make a dashboard, I select the report widget and try to add my report but I can't find them. However, when I use Browse or Recent on the left panel, I can find the reports. Can you tell me how I can find my report to place…