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
-
for column names with spaces, you need to enclose them in brackets [] like this
See the [Unique number] column
=INDEX({Funding approved date column in project schedule}; MATCH([Unique number]@row; {Project Plan funding column}; 0))
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
Thank you so much Darren that worked!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!