-
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…
-
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…
-
Stuck! Creating a Dashboard from a Sheet from a Report from Sheets. :/
Maybe I'm making this harder than it is but I can't figure out a way. I'm working towards ultimately building a Dashboard Chart (Pie Chart) based on Summary data from around 54 project schedules. I've created a Report that contains the information I need from the Summary information from each schedule (54 lines of summary…
-
How do I link data in my Marketing Shared Services dashboard?
I'm new to the platform (love it!) and deploying it to my University marketing team. I quickly jumped into Template Sets - Marketing Shared Services. Now I'm stumped, even after many videos. :) How do I create a formula in the "Shared Services Metrics (do not edit)" to pull correct data from "Shared Services Request…
-
Anyone use Smartsheet for tracking legislation?
I work for a state government agency, and this year we are developing a workspace to help the department track bills of interest/impact as they make their way through our state legislature when the next legislative session opens in January. Does anyone have any examples of what they use for something like this?