-
Dynamic Dashboard for Multiple Sheets
Our PM team is creating a dashboard for one of our clients based on multiple sheets/reports; however, the sheets will be created periodically (i.e., they won't exist when building the dashboard). Is there a workflow available to avoid the need to manually add a new sheet to the reports to roll up to the dashboard?
-
How to stack columns in a chart in increasing order?
I created a dashboard with a stacked column like this. I want stacks to go up in decreasing order (thickest one first and then the thinner one and so on). Is there a way to do this?
-
Help to Sort by number and words
currently we have a built in prioritization score based on the data entered on the intake form This will populate either a score of 1-5 OR the word "Tech" When filtering these through the report on our dashboard we want to sort in descending order but want those with the word "Tech" to populate last instead of first I am…
-
Formula to check box on header row if any rows nested under it have a specific owner/assigned to
Hello, I am trying to work out if the following scenario is possible. I have a bunch of parent tasks / child tasks. I have these child tasks feeding into a report/dashboard IF the assigned to is "Client" and want to include the headers where appropriate (ex. I don't want to pull through ALL the header rows on the sheet if…
-
COUNTIFS- CONTAINS/FIND/HAS
Set-up: I have a data prep sheet that references a master sheet and some other sheets so it is easier to set up a dashboard. I have a list of departments in one column (Column5), and the count formula in the next column. The formula works when there is one department listed in the reference but not if there are multiple…
-
How can I get the legend for a pie chart to display ALL series even when their current value is 0?
I've been having this issue while building dashboards for a while. I want to use a pie chart, the data contains 4 series. The values will update via their formulas over time, but right now the value for 3 of the 4 series is 0. For all of the other types of graphs, all series are displayed in the legend regardless of their…
-
Showing Sheet Summary Data in Another Sheet?
I am building SheetB to compare my budget by categories (data entered manually for now) against my actual expenses (entered in SheetA - totals for each category are part of my Sheet Summary data). Is there a way to reference those Sheet Summary totals in SheetB? Ideally, I will then be able to use SheetB to create charts…
-
Removing widgets from dashboard view if access is not already granted
When creating a dashboard some widgets will be hidden for certain users. The outline of that specific widget (report) is then still visible with the message stating it is not accessible. The widget should not be there at all. This results in the dashboard looking incomplete and I do not want questions from the blocked…
-
Add a Button To Collapse Or Expand a Grouped Report in a Dashboard
It would be nice if we could have it both ways on a dashboard. It can be frustrating that you can't collapse a grouped report if the person that set it up set it up expanded and vice versa. There could be a button somewhere on the report that collapses all or expands all.
-
Integration of interactive maps into Smartsheet.EU
Hello everyone, I hope you are all doing well! We are currently looking for a way to integrate maps into Smartsheet.EU (based on a database of distribution partners managed in Smartsheet). The purpose would be to filter locations (e.g. by postcode) to get a quick overview of possible partners for a given area and to…
