-
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.
-
How to identify the reports and dashboards to which an external contact has access?
To those in the know, I've been made aware a couple of dashboards and reports has been shared to an external contact over time. I'm trying to identify all the resources they have access too, so I can consolidate and streamline the reporting. Short of asking the external contact to do a screenshot of their personal…
-
How can I embed a .mov from GDrive to Dashboard without an error message?
I was able to get the embeddable link for the file on GDrive, but when I try to input the link to a Web Content Widget, I keep getting the same error message. The article it suggests for help is not helpful in "checking the link", and I'm not sure why it will not accept it. The permissions on the video are open - anyone…
-
Feature Request - Dashboard Line Chart Colour Change
Good Morning, Firstly, the rebrand of the dashboards is fantastic - I had raised this as a feature request late last year and am so excited to use the new background colours and widget colours. Really good - thank you and thank you for listening to user requests :) I do have a further request if I may? On a line chart, the…
-
Dashboard reports not showing on published dashboard in SharePoint
I have embedded a Smartsheet dashboard in a SharePoint Online site. Some reports show just fine, two do not and I can't figure out why. I published the dashboard and grabbed the embed code. Used an embed web part in SharePoint to embed the dashboard. Two reports show fine, the other two have errors. There is nothing…