Look up a project ID and return a date from another sheet

Hello,

I am trying to pull in the start date from another sheet. I have tried both Vlookup and Index, but have not been successful. Here is the formula that got me the closest, but I believe the formatting of the date isn't working. Date format is currently MM/DD/YYYY, I have also tried Month Day, Year.

Originating Data Set

Designation

Here are the references I am using

=INDEX({Master Folder Tracker Reference 1}, MATCH([Project ID]@row, {Master Folder Tracker Reference 1}, 0), 9)

=VLOOKUP([Project ID]@row, {Master Folder Tracker Reference 1}, 9, false)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!