-
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…
-
Is there a way to arrange data in a Metric Widget?
On my Dashboard, I have 3 metric widgets displaying metrics from 3 different departments via summary data from a sheet. 1 of the 3 widgets displays the information in an ABCD order while the other 2 display it in a DABC order. How can I reorder the data so that it is consistent and in the order I want? I would not think…
-
Graphs in Dashboard
Hello there, Is there a way to show targets in graphs? For example, I have this sample graph below from Smartsheet. Currently, my goal/target for this data set is shown in blue. However, what I would like is to show it in the following way. The black line is my target. Is this possible? Thanks in advance! Best, Lavanya