Multiple contacts selected to a task - calculating costs of effort

Hi,

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!

Thanks

Simon

Find more posts tagged with

Contacts

Formulas

Accepted answers

All comments

Paul Newcome

Do you have a table that lists out everyone in one column and their rates in another?

Simon Cowx

Hi Paul, yes thats correct

Paul Newcome

Try this:

=SUMIFS({Table Sheet Money Column}, {Table Sheet Name Column}, HAS([Name Column]@row, @cell)) * [Hours Column]@row

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.