-
Starting from scratch.
Hello community! I am new to Smartsheet and I am trying to work on a my Hospitals volunteer databases to bringing the 3~4 different programs that we have running into Smartsheet. We have one for each of the following; volunteer onboarding/application tracking, annual learning, volunteer time and location tracking, and…
-
Column Titles Appearing in Metric Widgets
I was recently building a dashboard and found that column titles were appearing in the metric widgets I was creating. Usually this widget would never such column titles. It was whatever was selected in the reference sheet. Does anyone know how to fix this? I do not want column titles showing up in these widgets. Example…
-
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.
