-
Help Pulling Information
Hi, Very new to using SmartSheet. Can someone help me understand if I can pull information from a Sheet in certain rows only that do not have a unique identifier. I just want it based on the answer from one of the columns. I'd like to pull information from 3 sheets into one based on what is listed in one column and in…
-
Creating a dashboard chart to represent the star symbol feature
Hello! We use the star symbols as a column in our project schedule to show the status of the project. I need to create a chart that shows graphically these statuses but have been running into many issues. To help, I created a column in the schedule that is automatically populated with the number of stars for that row.…
-
Dashboard - How to Add Dynamic Editable Text on Dashboards
Hi, I am working on creating a Dashboard where the Project Manager (PM) can input their Project Summary, which will then be displayed on their Dashboard. I understand that I can create a Metric Widget, connect it to a specific sheet, and point it to a particular cell. However, I need to ensure that this setup remains…
-
Cannot get donut chart to show legend
Hi, I am trying to get a donut chart to show the column labels as the legend but I cannot toggle that option on. I am using a Sheet Summary report and have tried a regular report with the data summarized but I cannot get anything to work. It is very simple but I do not know what to do since I cannot toggle the column names…
-
Adding a SS Dashboard to a public MS Teams Channel tab - not working
Hi there Is anyone having the same issue? In Feb i could add dashboards to a teams channel. Since then i havent been able to - i can add Sheet or Report no problem. Love to hear if others are having same issue
-
Unshared User Has Access to Dashboard
Hi all, I've encountered something strange and I'm wondering if anyone else has had the same issue. I recently used the Share > People with Access function to share a Dashboard to individual users. One person is not able to view the Dashboard via the email I shared to (his company email, same as the other users), but is…
-
Hi everyone, is there a way to create Dynamic view on a dashboard but with charts and metrics?
I am making a supplier-facing dashboard and I would like to make a dashboard that displays personalized data, similar to this video. Instead of a Month dropbox it would display supplier names and the data would ideally display specific or personalized info.
-
Report Not Showing the Correct Information on Dashboard
I am embedding a report onto a dashboard. The user that should have information displayed to them has permissions on the source sheet, report and dashboard. Even when I click into the report with the user's login information I can see the desired info, but when its displayed on the dashboard, it doesn't show any…
-
How to get values from "Symbol" column type in Dashboard
I have a sheet that populates a few reports, which are then displayed in a smartsheet dashboard. I have a column in the sheet titled "Schedule Health" that is a symbol type field. The symbols for this field push through to the reports: However, they do not push through to the dashboard. I get what looks like an error…
-
Chart Dashboard Widget using Sheet Summary data fields
It would be great to be able to use the chart widget with data held at Sheet Summary level. Appreciate that there are 2 ways around this : Create a report and chart against that Add "helper columns" to the sheet itself However, I'd prefer to reduce the number of new reports I'm creating, and keep sheet complexity lower…