How to Index Match

Paul Newcome

@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.

mrsci3ntist

@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!