Need the minimum start date for projects, what's the formula?

I'm trying to get the formula for the min start date based on the project number. So in the chart below the minimum start date for project 1 should be 11/5/24.

Tags:

Best Answer

  • Isis Taylor
    Isis Taylor ✭✭✭✭✭✭
    Answer ✓

    @Amy Merrill Use this formula in the Min Start column.

    =MIN(COLLECT([Start Date]:[Start Date], Project:Project, Project@row))

    Isis Taylor

    🎓️ Core App and Project Management Certified 🏅

    🌟Peer Connect, Mobilizer, and Early Adopter Program

    Business Analyst Senior

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!