-
Dashboard widgets not working - April 15th 2024
My dashboards using the Metric Widget are not working I get an error message "Source sheet unavailable". This is consistent with my dashboards set up in this way. The error is the same one that was experienced earlier in the year. Is anyone experiencing the same error?…
-
Survey Results from Form to Dashboard Chart
Novice Smartsheet user here. I created a Likert-syle survey using a Smartsheet form that has about 20 questions on it. I have results from five respondents so far. I would like to present this data in a Dashboard using the chart widget - one chart per question. Ideally, the chart would show how many respondents answered…
-
Dashboard widget is not displaying all of the data from the source report
Hello Everyone, Perhaps you can assist? I am the admin for our Smartsheet and have all permissions. I created all the reports and dashboards. Issue: Today, for the first time, a dashboard widget is not displaying all of the data from the source report. This is happening for all similar reports & dashboards. (See example in…
-
Customer Survey and NPS Scoring
I have set up of customer survey that includes an NPS question. I am not too familiar with reporting and dashboards yet, so I am having a difficult time envisioning where I should do my NPS calculations ie. Intake sheet, separate sheet, report, etc. This is also my first "solution" build. Currently, I am putting the…
-
NEW! Dashboard color themes
Hi Community! Dashboard color themes are here! Elevate the look and feel of your dashboard with just one click. No more picking random colors or spending painstaking amounts of time making sure the colors you want to use actually work together. Now you have access to 9 different color themes designed to engage and impress.…
-
WORKAPP VS. JUST A DASHBOARD
I have a Use Case where I'm deciding whether to use a just a Dashboard with Several Dynamic Views vs. setting it all up through a WorkApp. I have not used WorkApps yet, so am wanting to understand any advantages or features with using it. Use Case: Streamline our Single-Order process with a Key customer. [ They desired a…
-
COUNTIFS Function of # of Values Used in a Median Calculation for Metric Sheet
I have a formula in a metrics sheet where I am successfully calculating the median of values that meet a specific date range: =MEDIAN(COLLECT({Resi - Financial Approval Duration}, {Resi - Enter Stage 7 Date}, AND(@cell >= $[Start Date]$1, @cell <= $[End Date]$1))) I now want to calculate in a adjacent column the total…
-
View if sheet is referenced in a report or dashboard?
I am cleaning up the numerous sheets I've created. However, how can I see if the sheet is referenced in a report, dashboard, other? I do not want to delete a sheet that is in use.
-
Published Dashboards - CTRL+F availability
It would be very helpful for users to have the ability to search for keywords on published dashboards using CTRL+F. We use a published dashboard to provide all company help & information for Smartsheet. This helps showcase some of the functionality of Smartsheet from the start. We have multiple sections that we may refer…
-
Attachments sheet to dashboard.
Is it possible to do so that the attachments attached to the sheet would be automatically seen in the dashboard ?