Match resource in sheet 1 to resource in sheet 2 and then enter start and end date

Bruce Johnson

Hello Smartsheet Gurus

I have sheet 1 that has the names of people and a second sheet with those names throughout let's call that column assignee. Next to the assignee in sheet 2 is a column start date and next to that is end date. I want to bring the minimum date out of the column for each resource and max date for the same into sheet 1 under the start and end date respectively.

thanks so much

L_123

Min:

=min(collect({sheet2 Start Date},{Sheet 2 Name},Name@row)

Max:

=max(collect({sheet2 End Date},{Sheet 2 Name},Name@row)

How to build cross-sheet formulas:

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

Bruce Johnson

L@123 - thank you very much - this worked perfectly and thank you! you rock!👍️

L_123

Min:

=min(collect({sheet2 Start Date},{Sheet 2 Name},Name@row)

Max:

=max(collect({sheet2 End Date},{Sheet 2 Name},Name@row)

How to build cross-sheet formulas:

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

Bruce Johnson

L@123 - thank you very much - this worked perfectly and thank you! you rock!👍️