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

shuang

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!

Nic Larsen

Since its a cross sheet, I think this would be closer

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

shuang

https://community.smartsheet.com/discussion/comment/452965#Comment_452965

Hi, Thank you for your response. I tried that formula as well and I got an "Invalid Column Value" output.

Nic Larsen

Is your date column formatted as a date column? And the column in your sheet where the formula is, is it also a date column type?