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

Bruce Johnson

Director Portfolio, Project Methods & Governance

Veolia North America

Boston, MA

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!