Formula and Sheet Name

Options

I have several sheets that pull data from another sheet. On each of the sheets that pull from the one, each have multiple formulas.

If i change the name of the sheet with the data, does that effect the formulas on each of the other sheets.

Best Answer

  • SoS | Dan Palenchar
    SoS | Dan Palenchar ✭✭✭✭✭✭
    Answer ✓
    Options

    Hello @Robert S Fike,

    You can change the name of any of the Sheets as well as the columns themselves and even the column type (though depending on the nature of the formula changing the column type might invalidate your formula).

    Cross Sheet formulas map to the literal column itself and are maintained so long as the column is not deleted from the Sheet or the reference itself is not deleted from the reference manager.

    Hope that helps!

    School of Sheets (Smartsheet Partner)

    If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!