How to match collect an list based on role

Options

I have a sheet one column is role which has for example Project Managers, Network Engineers, Database Engineers performing tasks throughout the sheet. I have a start and end column for each task - I want to collect the start and end date based on role - what is the earliest date, latest date for each role.


Bruce Johnson

Director Portfolio, Project Methods & Governance

Veolia North America

Boston, MA

Best Answer

  • Bruce Johnson
    Bruce Johnson ✭✭✭✭
    Answer ✓
    Options

    nevermind - simpler than I thought. Max or Min is date column and collect is Role column. Brain damage on my part trying to make it more complicated than it needed to be.

    Bruce Johnson

    Director Portfolio, Project Methods & Governance

    Veolia North America

    Boston, MA

Answers

  • Bruce Johnson
    Bruce Johnson ✭✭✭✭
    Answer ✓
    Options

    nevermind - simpler than I thought. Max or Min is date column and collect is Role column. Brain damage on my part trying to make it more complicated than it needed to be.

    Bruce Johnson

    Director Portfolio, Project Methods & Governance

    Veolia North America

    Boston, MA

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!