-
Displaying report summary data in a Dashboard chart widget
I have 4 sheets used by individuals to track their work. I have a report that pulls from all 4 of those sheets to give me a total count of items they listed for the month as well as each line item (details of each listing). I have the data filtered, grouped, and summarized. The summary, for example, gives me 11 total items…
-
automating image display in a dashboard
One of my stakeholders is a big fan of visual information, and when viewing a dashboard, has asked for quick, visual way to assess the project health. I have a tentative formula for calculating that health (=IF(((COUNTIF([Risks?]:[Risks?], 1) / COUNT(Tasks:Tasks)) / 100 <= 0.1), "low risk", IF(((COUNTIF([Risks?]:[Risks?],…
-
Dashboard text fields
Hi, I have a sheet and the level 1 parent is serial number then under it is a level 2 parent with specs such as year: Make: Model: Can I make a dashboard that reports all the text that is after the year, make, model. Etc. So if I go to a dashboard I can see how many are a year 2020. The 2020 is entered by an employee.…
-
How can I
I'm trying to find a way of updating the column Term Expiration Date with the New Term Date column. I currently have a workflow that once a date is entered into the New Term Date it copies that row to a new sheet. The problem that I am running into is if I use the Data Mesh, or Data Shuffle it tends to update…
-
Merged: Text Wrap When Resizing Shortcut Widgets
This discussion has been merged.
-
Text wrapping for chart axis labels
I would love the ability to turn on text wrapping for chart axis labels in a dashboard. Smartsheet automatically tilts my longer labels in a diagonal style which is difficult for our company leadership to read/follow and makes the bottom of the widget so much longer, taking up a lot a valuable real estate in a dashboard.…
-
Dropdown list
Hello! I have a Smartsheet document with columns that have dropdown lists. When I enter a value into one of these columns that is not already available in the dropdown list, I want that value to be automatically added to the dropdown list without having to manually edit the list. Is there a way to set this up so that new…
-
User Permissions
I thought I might have understood permissions in smartsheet, but its not making any sense to me. I have 2 workspaces. Workspace 1 - Contains 1 owner and 3 admins at the workspace level. There are a set of multiple sheets, reports, and a dashboard within a folder and subfolders. This workspace is reserved as a template…
-
Widget size
Hello! Is there a setting that automatically expands the widgets as the lists in the widgets I added to the dashboard grow?