-
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…
-
Resource Management Schedule View on Smartsheet Dashboard
Resource Management already has a great view on the Schedule tab to see if someone is over allocated but unless you have licenses for every user in Smartsheet only Management can use this tool. I would like to create a view/report per individual that looks the same as in the Resource Management Schedule tab and place it on…
-
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…
-
Link to Dashboard on Sheets
Hello! I'm trying to figure out if there is a way to have a column on a sheet populate a link to a dashboard if the primary column is not blank. I know how to insert a hyperlink to the Smartsheet Dashboard, but it appears that cannot be converted to a column formula. I've tried creating the link as a Summary Field or on a…
