Pulling in earliest start date from another sheet based on one criteria

Hi Smartsheets Community,

I am trying to work on a formula that pulls in the earliest start date for a column (in another reference sheet) based on a criteria, which is the project type.

The current formula I have is:

=MIN(COLLECT([{Additional Items Target Start Date}]:[{Additional Items Target Start Date}], [{Additional Items Project Type}]:[{Additional Items Project Type}]), "Strategic Talent Initiatives - Mobility"))

I am trying to pull in the earliest start date from all projects that have their project type labeled as "Strategic Talent Initiatives - Mobility" but keep getting errors.

Thank you for your help!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!