Using the collect function and "Assigned to"

Hi all,

I am using the COLLECT function (within a SUM function) to collect all values associated with tasks assigned to a specific person. For example,

=SUM(COLLECT({Range of Values I am Collecting}, {Column where I have person assignments}, ="Person's Name"))

This isn't working for me... any tips?

Thanks!

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try this to include those rows where there are multiples listed:

=SUM(COLLECT({Range of Values I am Collecting}, {Column where I have person assignments}, HAS(@cell, "Person's Name"))

All comments

Paul Newcome

Are you getting an incorrect sum or are you getting an error? Is the [Assigned To] column a contact type column? Is it possible that there are multiple contacts listed in a single cell?

Aidan Connell

Hi @Paul Newcome ! I am getting the wrong values sometimes, so I am guessing that I am expressing the criteria incorrectly. The [Assigned to] is a contact type column. In some of these, there are multiple contacts listed.

Thank you!

Paul Newcome

Try this to include those rows where there are multiples listed:

=SUM(COLLECT({Range of Values I am Collecting}, {Column where I have person assignments}, HAS(@cell, "Person's Name"))

Aidan Connell

That worked perfectly @Paul Newcome ! thank you my friend

Paul Newcome

Happy to help. 👍️

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.