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?

Find more posts tagged with

Formulas

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.