-
Current user metric widget
I have an evaluation form that gets filled out and results can be viewed on a dashboard. I have two, one for the submitter to see only their entries and one for the location being evaluated and the viewers see only the evaluations that are pertinent to them. I have a sheet summary formula that counts the total visits and…
-
Checkbox Used as Input in Dashboard
Has anyone ever used a checkbox input from a dashboard in a formula to include/exclude certain data in a calculation for the dashboard? I currently have a dashboard where I ask the user to input a date range that would be used to parse all of the data that could be shown in a dashboard to only the data in a date range.…
-
Metric Widget Font Size
It would be really great if we had a much wider range of font sizes available for metric widgets. Sometimes a metric really needs to make an impact, and the current size options are limited.
-
Metric Widget without Summary Sheet Report?
I'm trying to figure out a formula-free way to show summarized info. 😅 I have 3 Cities on my Sheet; each city has 'co-parent' rows, and under these co-parent rows are Tasks that have a Status. I'd like to have a Metric widget on my dashboard that shows the number of Tasks per Status, per City - for example, 'Tulsa' In…
-
Widget Report Format
Hello. I am building a dashboard with high level information including total requests submitted into the sheet. I was able to create a report and add it to the dashboard but I do not like the formatting. Is there anything I can do to customize and center the total number?
-
Linking data from multiple sheets to one master sheet - then to a dashboard
Context: I have a team of people with their own individual smartsheet trackers that each contain identical columns. I want to have the rows on those individual trackers automatically populate/update in one master tracker where I can see everyone's data at once. I have already tried reports - this doesn't work for me. The…
-
Widget size
Hello! Is there a setting that automatically expands the widgets as the lists in the widgets I added to the dashboard grow?
-
Help with sheet summary formula losing #REF with data shuttle
I have a dashboard created with a "Data Date" Metric at the top. Using the Created column to populate a "Data Date" column (text column +LEFT(Created@row, 18) I can add the date in the metric via a sheet summary field. When I refresh data pulled from an Excel sheet (exported by another program), I get a #REF error in the…
-
Dashboard Widgets
Hello, We are in the process of revamping our dashboards, and our manager has provided a screenshot (first image) as an example of the desired widget layout located in the top left corner. However, we are unsure if it is possible to replicate this exact design. The best we have managed so far is depicted in the second…
-
How do I get a date value to show/change in a dashboard?
I have inherited and existing Smartsheet, which I am just learning. The dashboard has a metric widget with a week of, but it does not change we are stuck on one week. I have a column that is now labeled as "Week Of" the cells show the date as 07/28/24 and the column type has been changed to date. How do I go about setting…