How to Index Match
Answers
-
Hi @Paul Newcome,
Similar question, but here my extended question is how to make the following into a column formula ? (Note this is a screenshot of a sheet from within Smartsheet's "Project Management Office" template workspace). The issue lies with the [column_index] always matching to the first row which will not work in a column formula.
Thanks for your help!
-
@mrsci3ntist You would need to hard-code "Project Name" and remove the $ from before [Project ID]@row. Otherwise you are looking at a drag-fill situation. Once you have a few rows, Smartsheet does have an auto-fill feature that will pull formulas in even if they are not set as column formulas so long as you have at least two populated rows above and/or below the new row.
-
@Paul Newcome, I just tested this and you're right Smartsheet does indeed continue the formula for new rows even though they aren't column formulas! I should have kept working away and would've likely spotted that. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!