Column function not working on select rows with Index Match

Hello Community,

I am at a loss on this issue. I have two sheets; I use one (Reporting Sheet) for external resources to report status into via reports, and the second (Master List) I use to house lots of data about projects and pull-in the reporting data. I have column formulas to pull information from the Reporting Sheet into the Master list using the project ID to link. All my rows/formulas were functioning, and then I updated a project ID, and the rows I changed are now no longer pulling as expected (they are pulling from a different ID altogether - but all the other rows I didn't touch seem to be fine).

Here is an example of my formula in the Master List:

=INDEX({Schedule Health - Reporting Sheet}, MATCH([Project ID]@row, {Project ID - Reporting Sheet}))



Best Answer

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓

    Do you have a lot of rows?

    Try adding to the MATCH function as shown below:

    =INDEX({Schedule Health - Reporting Sheet}, MATCH([Project ID]@row, {Project ID - Reporting Sheet},0))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!