Match resource in sheet 1 to resource in sheet 2 and then enter start and end date
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
Help Article Resources
Check out the Formula Handbook template!