-
Using =MAX( to get latest date on Dashboard
HELLO! I am trying to get the very last date on a sheet to display on my dashboard. I am using the MAX function to return the date but I keep getting an error…..I have tried the below =MAX({Target Complete}) ….this returns #INVALID COLUMN VALUE =MAX({Target Complete}:{Target Complete}) ….this returns #UNPARSEABLE…
-
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…