-
Turning Excel Data from a Survey into a Dashboard
Good evening! Once again, I am leaning on the brilliance of this community to help me with an issue. My boss gave me the data provided below. Each question is different, with different answers. He wants me to put the data into a dashboard by tomorrow. Is there a simple way to do it? I've been trying to wrap my mind around…
-
Creating and Sharing Dashboards
Hello Community! I am starting to get really good at creating dashboards, but wanted to chat about best practices. I can foresee the need to create externally facing dashboards for our customers but wondering what the best way to do that is so that it doesn't become super time consuming. Is it best to create a copy of the…
-
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…
