-
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…
-
Continuous line with data gaps
Is it possible to get a continuous line in the line graph on the dashboard with a gap in data. Note that not a zeo, but there is no data for that month as shown in my picture below:
-
Filter Report Based on Cell
I have some reports in a template dashboard that I would like to filter based on the data within a cell. For example, I have a report to show a project's weekly update. I would like the template to look at the project name in the metadata to filter for that project's weekly update instead of having to manually update the…
-
Horizontal axis labels not showing in mobile app
Hi, I'm having issues with the horizontal axis labels not showing properly on graphs in the mobile app. When building the dashboard on desktop, the labels are all there and automatically adjust to diagonal to ensure they're displayed. However, in the mobile app the labels revert to a normal orientation, and because they'd…
