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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!