Master Metric sheet. Multiple users to 1 row
Hello
I am using a metric sheet to show owners total tasks in their name based on status (initiate and overdue). The first column is owners name.
All of the tasks have 1 owner only except for 1 row which has multiple owners. How do i make sure their metric is included in their total calculation below?
Each row below is shown as a metric on our dashboard. The users name and how many tasks in their name that has the below status.
Answers
-
Is the owner name a multiselect drop down? How are you calculating the single-owner rows?
If you are using a multislect and a function such as COUNTIF or SUMIF, you can use the HAS function within the criteria. This would then work on both of the names mentioned in a multi-owned project.
-
Hi KPH
The owner column on the sheet is a contact list that you can select multiple owners.
On the master metric sheet (picture above) I am using a reference formula =COUNTIFS({SHEET1}, $[Primary Column]@row, {SHEET2}, [Column1]$17)
This is the formula i use on my metrics sheet (picture above). The Primary Column is the owner, Column1 is the status. eg: Initiate
How would include the HAS function on the metrics sheet?
Thanks so much
-
-
Hi there
This returns a value but not the correct one.
-
Can you share a screenshot of the sheet with the data in and the result you get? (you can obscure names if needed, just add something to identify one or two in both sheets).
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives