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

Amy Merrill

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.

Isis Taylor

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

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

Isis Taylor

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

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

Amy Merrill

That worked! Thank you so much Isis!