Pulling Adjacent Cells

Danielle Ferrari

Hello,

I have a column of task due dates, and an adjacent column that lists who the tasks are assigned to. In a separate column, I have a cell that shows the next upcoming due date using a formula. I would like to pull in a cell next to that the corresponding person that that next upcoming due date is assigned to. Which formula lets me show an adjacent cell to the one which the value is pulled? Aka I would like to show who the next upcoming task is assigned to.

here is an example:

due date assigned to next upcoming due date person next task is assigned to

3/1 Sarah 6/2

6/2 Ron

In this case, I would like the cell under person next task is assigned to to pull "Ron" since that corresponds with the next upcoming due date.

Thanks.

Danielle Ferrari

@Paul Newcome what should go in the COLLECT parenthesis?

Paul Newcome

You would replace

MIN(COLLECT(...............))

with whatever your existing MIN/COLLECT formula is to pull the date.

Bassam Khalil

Hi @Danielle Ferrari

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Or if you like to fix the formula directly on your sheet please share me as an admin on a copy of your sheets ( Source & Destination ) and i will write the exact formula for you then you can copy it to your original sheet.

My Email for sharing : Bassam.k@mobilproject.it

Andrée Starå

Hi @Danielle Ferrari

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Danielle Ferrari

Here is the spreadsheet. I used a =MIN(COLLECT formula to calculate the nearest upcoming due date, and I would like to pull the person that it is assigned to along with it somehow so it will go under "Upcoming Assigned to" @Andrée Starå @Bassam Khalil

Paul Newcome

I would suggest something along these lines...

=INDEX([Assigned To]:[Assigned To], MATCH(MIN(COLLECT(..............)), Finish:Finish, 0))

Danielle Ferrari

@Paul Newcome what should go in the COLLECT parenthesis?

Paul Newcome

You would replace

MIN(COLLECT(...............))

with whatever your existing MIN/COLLECT formula is to pull the date.