IF formula for earliest date

Alessandro Terranova

Hi Community,

Could anyone please help with this formula syntax?

I want to capture what is the earliest date within a date range for a specific role, "Production" in this case.

=IF(Role:Role, "Production", COLLECT([Actual Start]:[Actual Start], [Actual Start]:[Actual Start], MIN([Actual Start]:[Actual Start])), "")

It would return the earliest date if a date is set and blank is no dates set yet.

Many thanks in advance for your input and your time.

Best,

Alessandro

Paul Newcome

Try something along the lines of...

=MIN(COLLECT([Actual Start]:[Actual Start], Role:Role, "Production"))

Paul Newcome

Try something along the lines of...

=MIN(COLLECT([Actual Start]:[Actual Start], Role:Role, "Production"))

Alessandro Terranova

Many thanks Paul! Much appreciated!

Paul Newcome

Happy to help! 👍️