-
How to access all columns in a Report when creating a Dashboard Chart?
Hello! I have a report that is summarizing project costs, sorted first by the line-item code in the budget and then by Quarter of Completion afterword. I am hoping to represent this data graphically with a dashboard chart. The goal is to have a Bar Graph that shows the cost in each quarter, clustered by the budget item.…
-
How do we make Graphs look the same on desktop and mobile dashboard
We have a dashboard that has 3 graphs in it, based on reports. On the desktop version Y axis starts at 0 and has specific colours for the different lines. On the mobile version the y axis starts at -2 and has different colours for the lines. This is on all 3 graphs. How do we make them be the same graphs?
-
Dashboard widget cant save as it request data validation
hi im using smartsheet trial version. im trying to create a dashboard of my reports from various sheet but it cant be saved and requesting for data validation. can help me on this?
-
Dashboard to show Report's Highlighted Changes
Hi! I setup a report to show the most recent changes but the formatting is not coming over on the dashboard. Is there a way to do this? Report: Dashboard: Please let me know if there is a setting or something else I am missing! Thanks in advance!
-
Summary Fields for Dashboard based on dropdown values
Hi All, I have a rewuirement and, although I have a solution, it is very manual. I was wondering if there was a better andmore efficient way of doing what I needed. It is a question of reverse engineering in that my requirement starts with the end product a dashboard. On this dashboard I wish to show, in graph format, how…
-
Skipping the middleman (calculation sheet)
The company I'm working for has a database that houses info for our external clients, the database is constantly being updated nearly daily, I currently utilize a separate sheet to perform =countifs contain functions to create visuals on a dashboard for various statistics based off the columns of information as it updates.…
-
Creating a widget for tracking the tasks for each member of a team
Hi. For the past few days, I've been trying to create a dashboard to track the tasks that each member of my team has. I learned that the best way to do this is to create a separate sheet where I used formulas to create a set of data and then use those to create charts in my dashboard. However, when I tried to use a formula…
-
Hyperlinks in sheet - Sheet embedded in a Dashboard - not appearing.
I have a source sheet that contains hyperlinks to reports. The source sheet is published as "Read Only - Full" The published sheet is embedded in a dashboard as a "Web Content Widget". None of the Hyperlinks are visible in the dashboard. When selecting the cell it displays cell info as shown below - The "Sheet" link has no…
-
Is there a way to show those who will be out on PTO and what deliverables overlap with those dates?
My vision is to show calendar/widget of individuals that are out of the office/pto and which deliverables overlay with that time off.
-
Trying to create Chart widget based on report - but report not showing up as data source option
Hi there! I'm working on a dashboard on which I want to add a chart that displays a bar graph representing the data in a report (report is titled "Tasks in Next 8 Working Days, by Staff"). When I select the widget to create the report, I can select other reports in the workspace, but not this one. I'm baffled because I…