Formula to collect resource's start date



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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!