Cross sheet reference formula drag to other cells

Dovy

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?

Ryan Sides

@Dovy No dice. No way to update that cell reference that way. I've done something similar in excel before where I built the formulas there and copied them over as text into SS, but it was still clunky and I had to edit each cell anyway.

Dovy

https://community.smartsheet.com/discussion/comment/357246#Comment_357246

och, thats what I though.. Thanks for your reply.