Creating a Formula
I track projects and assignments in 1 sheet.
There may be 1 project that has 3 assignments. Because Assignees are tracking indicating time spent on a project, there needs to be a separate line for each assignee - therefore the project is listed 3 times in a sheet. When I pull metrics, currently, the 1 project may be listed 3 times (1 for each assignee)
Example: ABC Project is assigned to A, B & C; the project's Business Unit is XYZ
I pull metrics for
Projects for each Assignee (A,B&C)
Projects (In Progress, Not Started and Completed) for each Business Unit
Can any help me try to create a formula that says if 1 project is assigned to more than 1 Assignee, only count it once AND only count the Business Unit once also?
I hope I am explaining this correctly
Help Article Resources
Check out the Formula Handbook template!