Formula to collect resource's start date

Mallory M.

Hello,

I am trying to create a formula that will collect the min. date for the resource listed at row for various projects. If the resource isn't listed as a task owner, Right now, I am getting a blank response instead of my initial start date for a project.

Current Formula:

=IFERROR(IF(CONTAINS(Resource@row, {Task Owner}), MIN(COLLECT({Start}, {Task Owner}, CONTAINS(Resource@row, @cell))), ""), "ERROR")

Sheet Info:

Resource column type is Contact List - restricted & doesn't allow multi select

Project 1 Start Date is a Date Column - restricted

Cross References:

{Task Owner} is a Contact List type - restricted & doesn't allow multi select

{Start} is a date column - restricted

Thanks!

Paul Newcome

Try swapping the CONTAINS unction for the HAS function (note the different syntax). CONTAINS doesn't work on contact type columns.

Mallory M.

@Paul Newcome Thank you for you assistance! I learned something new! I did try swapping it with the HAS function, but it is still populating blank.

=IFERROR(IF(HAS({Task Owner}, =Resource@row), MIN(COLLECT({Start}, {Task Owner}, HAS(@cell, =Resource@row))), ""), "ERROR")

Paul Newcome

Ok. It looks like the IF potion is not registering that the Resource@row exists in the range.

Lets try without and see what happens:

=IFERROR(MIN(COLLECT({Start}, {Task Owner}, HAS(@cell, =Resource@row))), "ERROR")