Trying to collect data from a sheet where a person assigned is one of multiple contacts

LauraBall

Hi,

I'm trying to revise a formula and am a bit stuck on how to do it. I would like to pull resource utilization information from my Project Plan into a Team sheet (and no, we don't have the Resource Management module or Control Center at my organization). Here is an example of the current formulas I'm working with:

=MIN(COLLECT({Project Plan| StartDate}, {Project Plan| Parent Title}, Phase@row, {Project Plan| Assigned To}, Stakeholder@row))

These were for a Project Plan where the "Assigned To" column is limited to one person. We'd like to allow that column to have multiple contacts assigned. Normally I'd use some sort of CONTAINS function, but can't figure out how to revise this particular formula.

Paul Newcome

You would actually want to use the HAS function.

=MIN(COLLECT({Assigned To}, HAS(@cell, "John Doe"))