-
Dashboard Assistance
Currently, I have a dashboard that reports on our Current and Completed jobs (two unique sheets). There's two fields I'm looking to add together and return the sum onto the dashboard to display our dynamic Currently Billed to Date number. Datapoint 1 - exists in the Sheet Summary for the Current Projects sheet. This…
-
Dashboard Sheet name Hyperlink proposal
I have a dashboard with a summary report that shows all my records within my Smartsheet, within the report i have the sheet name column which acts as a hyperlink and takes the user to the associated sheet where the record is located. The problem is the link takes the user to the page but leave the user having to go and…
-
New and Ready to Build!
Hello all! My name is Sarai and I work for a municipal government in Texas. I'm new to Smartsheet and love learning new things. Currently, I am building an inspection compliance tracking sheet to oversee about 400 sites. Is it possible to build a dashboard that showcases all aspects of a single site based on an ID number…
-
Setting up Data & Configuring Gradient Bar Chart
Hello! I am trying to show a gradient bar chart in a dashboard. I have a sheet where I've pulled a report that has data for US States. Each state has a count for Yes, No and Blank. I want to represent a bar chart in a dashboard for this data that shows the Yes, No and Blank count information as a gradient. Below shows the…
-
Why is my sheet not showing up as a data source for a metric widget
Hello, I have two sheets in a workplace as show below. However, when I go to add a metrics widget to the dashboard only one sheet shows up as a potential data source. How do I get the other sheet to show up as a data source. As of now the metrics sheet is a column of descriptions, then a column of the calculations. The…
-
Dashboard can't be publish
When I want to publish my dashboard, it always show me an error message. The situation continue few days. How can I resolve it ? thanks.
-
COUNTIF for Items in Dropdown Menu and Name From Another Column
I am trying to make a metric sheet to populate information for a dashboard. The originating sheet is from a survey/form. I would like to count how many times each category is paired with the Highest Level Person in Attendance column. For example, How many times the SVP is attending the Internal Audit Program topic?
-
Dashboard Sharing
Hi All! Aside from sharing it using a public link, I was pretty sure that dashboards functioned like reports, where a user had to have access to the supporting/underlying sheet to access the information. Has that changed? And if I was wrong from the beginning…I guess my real question is: I do not want to make my dashboard…
-
Is there a way to set the default custom color palette on a dashboard?
We are not a part of the EAP program and recently noticed a new default custom color palette set for net new dashboards. Not seeing any documentation outside of logo and task/background colors that a sys admin can set at the plan level. We would prefer that this be set to follow our company approved colors. Is this a newly…
-
Ability to set font size in report
I would like the ability to control the font size in a report independently from the base sheet. Currently, the report font size is controlled by the base sheet. I have a sheet with a font size of 10, and it is readable on my computer. I created a report with this sheet and put it on a dashboard, but the font size seems…
