-
Dashboard Template Suggestion
Hello, I browsed the templates but I couldn't find what I need so I'm looking for some suggestions. I have 2 projects that I want to show the timeline status and attach some high level docs. The less widgets the better. Also, I will include a form for suggestions. Thanks,
-
Collect multiple project names in Portfolio Rollup?
Data is collected in this example intake sheet below and the metrics are summarized in another metrics sheet below. The following formula collects the Project ID and gives the count per associated Platform and Status. However, I need to display the Project Name as well as the count on my portfolio dashboard. How can I fix…
-
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…
