-
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
-
Looking for Dashboard Help - MTD, QTD, YTD Representation
Hi folks! Looking for help on how to best represent 15 different KPIs on a dashboard(s) with the ability to indicate the period (MTD, QTD, YTD). I realize we can't dynamically filter dashboards so instead of creating multiple dashboards (one for each period), is anyone creatively solving for this? If so, how? Without using…
-
How to properly use a scatter plot graph?
Hello all, I am in need of representing data through a scatter plot. Currently I have 2 main columns each numeric and the respective project name. My two numeric columns include data for project urgency (a given value from 1 to 5) and a total score for the project. I want to be able to have this data represented through…
-
How to solve inconsistent display of published calendar on dashboard?
I have an issue with the calendar app embedded into a dashboard. My team is seeing a different view than I am, and this changes depending on the day. Today, here is what I see: And here is what my team member is seeing: We are both admins on the dashboard (though I am the owner), and the calendar is published (although we…
-
Time Line Chart Query
Hello Experts, I need to build a time-line chart with Planned Vs Executed comparission. Possibly the count would be the Test ID count. Status is fine. How can I achieve this solution in the Dashboard?
-
Drop down on dashboard pull all matching rows
I am trying to build a dashboard that will allow someone to enter a Asset# and it will pull all rows from a sheet that match that Asset#. The Primary Column is a Inspection number that contains the asset# and date. There is a separate column that is the Asset#. It would be even better if it would show it from youngest to…
