Formula and Sheet Name
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
-
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
-
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!
-
TYVM
-
@Robert S Fike my pleasure!
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
These are helpful. Is there a class you teach or just do videos
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!