IF formula for earliest date

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 Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!