-
Dashboard - can reduce Rich Text Widget
I have a large Rich Text Widget box on a Dashboard and have it sized it exactly to the text I have. But no matter what I do it still has the scroll bar with a large space. I have no extra spaces or text, I've deleted any extra space and when designing/ populating the Rich Text widget, no extra space is there, only when I…
-
Dashboard Rich Text Widget Excessive Vertical Scroll Bar
Is anyone else's rich text widget have excessive amount of vertical scroll bar action? My OCD always tries to prevent users having to scroll vertically. I have used Smartsheet for over 7 years and never had such excessive white space in my widgets despite trying to expand the widget that should definitely prevent vertical…
-
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