-
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.
-
Using COUNTIFS to find a partial text match in 1 cell + other conditions
Hi Smartsheet Community, I'm having trouble with a COUNTIFS formula and hoping you can help. I'm trying to count all rows that are assigned to a specific person. Because it's possible to have multiple assignees for a task on my sheet, I need to do a partial match for the assignee name. Here is the formula I've created:…
-
Pie Chart breaks when values are zero
In a dashboard, pie charts are breaks the reference and shows as Unable to display chart when reference values are changed to zero as these vales calculated via formula. Only Bar charts are showing as No data to display. My end goal is to show as No data to display when values are zero. Kindly help me out here.
