Calculating costs for tasks with multiple assigned reources


I am using the following formula to calculate the effort costs for a task. It references a list of resources with allocated rates. For a task with one resource assigned, this work fine.

=[Effort (hrs)]@row * INDEX({Rates}, MATCH([Assigned To]@row, {Names}, 0), 6)

However its not good for tasks with multiple resources assigned. How can it split out each resource assigned to a task within the formula and then calculate the effort costs for each?. I know each resource name is separated by a comma.





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!