Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Cross sheet reference formula drag to other cells

    ✭✭
    in Formulas and Functions

    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:
    · Share on FacebookShare on Twitter

    Answers

    • Community Champion

      @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.

      Ryan Sides

      Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube

      Come Say Hello!

      · Share on FacebookShare on Twitter
    • ✭✭
      Ryan Sides

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

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions