Index/Match Function returning Unparseable

Hi Team, I am attempting to pull in dates from a Project schedule into a Program plan across 2 smartsheets. I have used several variations of Index Match with no success. My key indicator is a unique number in both sheets.

Exp: I would like have the formula return the funding approved date from the project schedule into the Program Plan. This formula would then be copied down to the rest of the unique numbers in the list to pull in all of the dates from the project schedule for funding.

INDEX - Funding date from the project schedule

MATCH - Unique number from the Program Plan and the Project Plan Funding Column Date.

=INDEX({Funding approved date column in project schedule}; MATCH(Unique number@row; {Project Plan funding column}; 0))

Really lost on how to make this one work. Any help would be so greatly appreciated.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!