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!
Answers
-
Try swapping the CONTAINS unction for the HAS function (note the different syntax). CONTAINS doesn't work on contact type columns.
-
@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")
-
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")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!