Reference another sheet

Hello,

I would like reference another sheet but the sheet reference name remained the same.

I would like reference into the Sheet Master but its blocked toanother sheet.

You can see in the print screen

Thanks to help me


Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Eric Laitenberger

    Based on this image, it looks like you're Editing a current reference instead of replacing a reference, is this what you were looking to do?

    For example, if you have this formula in your sheet:

    =COUNT({Column Reference})

    And you clicked "Edit Reference" to change the column, this would update every single reference in your entire sheet to now look at the new column.

    Instead, you would want to delete out the reference:

    =COUNT({Column Reference})

    to

    =COUNT( )

    Then click "Reference Another Sheet" and create a new reference to a new column. This way all your other formulas will stay looking at the previous column but now this new formula is looking at a different column. See: View, modify, or delete cross sheet references in formulas

    Let me know if this makes sense or if I can help explain further!

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!