Creating Personal Dashboards from Team Data
I'm in the process of trying to create personalized dashboards for each team member from data that is collected via forms they submit to track their daily work. The goal is to have a dashboard for each team member to access that only they and their manager would be able to view their numbers from the total submitted by the team. I'm also hoping we would be able to add in some additional details so they can see their numbers based on each quarter of work (i.e. January to March).
It's my understanding that to make these dashboards private, there would need to be some kind of metrics report created to pull those numbers from the master sheets. However, I've been having challenges with the formulas to count the total numbers for each column and not just the number of times they've submitted something within that column. SUMIFs formulas haven't been cooperating and COUNTIFs will only count the number of submissions (not the total numbers within each column/category). Would someone be able to provide some more insight on this please?
Answers
-
Can you provide a few examples of the SUMIFS that you have tried but aren't working?
-
The goal is to pull total numbers/task for each individual. Ideally, we would also be able to have it include a specific time range (i.e. January to March, then April to June).
-
The SUMIFS is missing the very first piece which is the range to sum.
-
In this case the range to sum we would want would be the ATAs sent, but only for a specific person. What would you recommend to use to have it determine this?
-
Are you trying to add numbers in a column or are you trying to generate a count?
-
It would be generating a count for each person per column. As an example: Adam completed X number of tasks from column 1, 2 & 3 while Jessica completed X number of tasks from column 1, 2, & 3.
-
-
Hi All, I was able to get the COUNTIFS formula to work, but it is only counting the number of times something was submitted/entered for that task. It is not counting the totals for the numbers entered in that task
As an example:
The individual completed the task 14 times on Monday, 22 times on Tuesday, and 19 times on Thursday, but it is only counting the 3 instances that a number was entered and not the total number of 55 times the task was completed.These counts need to be completed for each individual for multiple tasks/columns. There are 10 different tasks that I need to gather data on for 10 different individuals. Could someone provide some more insight on how to get these formulas set up accurately?
-
