updating all formulas
Hi there, I know this has been mentioned many times but I was wondering if there is a quick and easy way to update all formulas to reference new sheets. We had everything originally setup per year on each cell that references other worksheets. For instance "=COUNTIFS({2023 Incident Investigations Range 4}, "1", {2023 Incident Investigations Range 2}, [5]1, {2023 Incident Investigations Range 3}, $[Primary Column]2)", I would like to update all of these to reference 2024 sheets now. I have full Admin console access to everything as well, not too sure if that helps. Obviously if find and replace worked for formulas I could do a quick update to everything but that doesn't seem to work. I see references that is if you have control panel access you might be able to do something. I am not super familiar with the program, just lending a hand to update things for next year. Thank you!!
Best Answer
-
Not necessarily. If you put everything into a folder and then make a copy of the folder, all of the stuff in the copy will be linked to the appropriate places within the copy and all of the original links will still be linked to the original places.
Answers
-
Your best bet is to make a copy of everything, store the copy as your 2023 historical data, then overwrite the data in the sheets already containing the links with the 2024 data.
-
HI Paul, thank you for your reply. If we made a copy of everything we would lose all of the links referencing things I would assume, correct? we have three worksheets, 2 with no links but they all link to the one spreadsheet.
-
Not necessarily. If you put everything into a folder and then make a copy of the folder, all of the stuff in the copy will be linked to the appropriate places within the copy and all of the original links will still be linked to the original places.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!