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

Bruce Johnson
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

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!