-
Column Formula Needed: Days remaining until action resolution is needed.
Column in Main Sheet: Ultimately meaning there are T-X days until resolution action is needed (helper column). I have thrown the ranges that I am wanting to report in to another sheet, for calculating the count for each range/category. Formula isn't working and there is where my struggle lies. Formula: =COUNTIFS({Coding…
-
Adding to a report
Hello! So - I am working on building dashboards for my company where we can track To Dos. goals, etc. I have made reports, added them to the dashboards, and connected the report widget back to the data source (data source being the report NOT the original sheet). My question is - is there a way for people to just add line…
-
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.