-
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…
-
Dashboard label values overlapping
I wanted to show sales figures in the dashboard, but values overlapping with other data. Can anyone help me to solve this problem?
-
Restrict Values in Dashboard?
Hello Community, I have a dashboard that I allow a team to view. Each team has their own book of business, and I want them to be able to see how much money they have available in an easy way. I calculate it with formulas on the back end, and want to provide it in the existing dashboard. Is there a way I can restrict…
-
Array and Index Training Records to pull who needs to complete something within a date range
I manage training records and am creating a dashboard to manage who needs to complete a training. I have a master sheet with the employee name, and a reference column to them completing the training and when it is due I then have a calculation sheet to count how many people fall within that date range =COUNTIFS({HiPot…
-
Unable to edit dashboard with Admin rights
Hello all, I have added a user as an admin for a dashboard but she is unable to see the edit (pencil) button. Tried adding her as admin in the workspace but still doesn't work. Any idea? We are on Enterprise plan. Thank you.