-
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…
-
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.…
-
Merged: Text Wrap When Resizing Shortcut Widgets
This discussion has been merged.
-
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?
-
Dashboard Improvement general post: for specific features find the related idea instead
Modestly, I create beautiful dashboards and the team likes it. It helped a lot to spread Smartsheet within our company. But it is still very limited in terms of design possibilities. The visual aspect is very important for engagement and there is no way to compare it with other dashboard apps that we have on the market,…