Formula to collect resource's start date

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!

Find more posts tagged with

Formulas

Project Management

Accepted answers

All comments

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

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.