-
Add Work Insights to Dashboards
I am trying to add summary charts to a dashboard, however it requires numerical values which are impossible to add for what I am trying to show in the chart. Excel can easily create a variety of charts to show me how many cells in a column show specific data, and the Work Insight in Smartsheet also shows me the data in the…
-
Merged: Work Insights -> Dashboard
This discussion has been merged.
-
Merged: Single Dynamic Filter
This discussion has been merged.
-
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…