Multiple contacts selected to a task - calculating costs of effort
I have hourly rates for employees that are in the contact list.
I calculate the costs of tasks assigned to a single contract with with no problem. However where multiple contact are assigned I cannot find a way to split out the contacts selected to then allow me to calculate their costs at individual rates
Fred £10 per hour
Mike £15 per hour
Dave £20 per hour
Task 1 : Fred for 2 hours = £20
Task 2 : Mike & Dave for 1 hour = £35
However for task 2 how do I pull out the names selected as multiple contacts allocated to the task, to allow cost calculation?
Hope the above makes sense!
Help Article Resources
Check out the Formula Handbook template!