Cross sheet reference formula drag to other cells

Options

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?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!