-
Dashboard access issues
Hi all, I have a number of organisational dashboards set up. When I use the "only available to users on the same Smartsheet plan" publish option, I have constant access issues with colleagues not being able to open it and having to send requests, in spite of the fact that they are all in the account user list. Am I missing…
-
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…