L@123’s Profile

Community member since June 2017

points
1251

2

Hi,

I have total of 1200 tasks and 3 Assignees and I need to count : ( I want to create a Mini Dashboard on the top of my Task Sheet)

1. Total Number of 'Completed' by All 3 Assignees,

2. Total Number of 'Completed' by each of my Assignees.

3. How many tasks have been selected 'completed' from my

2

Hello - I need some help with the children formula.  I am trying to reference another sheet and only pull info from the children of specific hierarchies.

The only way that I can do it, as of now and with my current skill set, is if I select all of the actual children.  I realize this will be out of