Multiple Contacts and effort total
I am tracking tasks with an Assigned To column and Effort column. My original sheet required repeating the same task and assigning to each individual who would perform that task, and then using the Sum(Children()) to get the total effort for all child tasks.
I would like to allow the Assigned To column to use multiple contacts, with effort set to the amount per user, and then sum up the row.
Task | Assigned To | Effort
Task1 | user1, user2, user3 | 1
Task2 | user2, user3 | 2
I would expect the total effort to be (3*1) + (2*2) = 7
I haven't figured out a formula that would give me total effort of child tasks with multiple contacts. Any ideas?
Help Article Resources
Check out the Formula Handbook template!