Using the collect function and "Assigned to"

Aidan Connell

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!

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"))

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. 👍️