How to Index Match

mrsci3ntist

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!

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!