Cross sheet reference formula drag to other cells


Hey guys. I have 48 cross-reference links that I need to add to the columns. I would like to drag the formula so that I won't need to change the reference # manually for each of the columns. My formula looks like this

=IFERROR(INDEX({ProductionHopper Range 2}, MATCH($[Job #]$@row, {ProductionHopper Range 1}, 0)), "")

the sheet reference ProductionHopper Range 2 should change in each column by dragging to ProductionHopper Range 3, ProductionHopper Range 4, etc. Is it possible?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!