How to Index Match

2»

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!

  • Paul Newcome
    Paul Newcome Community Champion

    @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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!