Referencing other sheets
![CherylAK](https://us.v-cdn.net/6031209/uploads/drupal_profile/files/2019-09/22/c6/n22c6224e4ddcb1a4bfbbf4e52e2e6245.jpg)
Ok I have one sheet that I have a formula in that references the data in another sheet.
The name of the source sheet is "Drug Seizures"
When I start my formula in the destination sheet, I click on reference other sheet, select "Drug Seizures" and then the data I want to reference.
When I look at the formula in the destination sheet...it is calling my source sheet "STREET Drug Seizures"
The name of the sheet is Drug Seizures, not STREET Drug Seizures. Why is it adding the word STREET?
This one has me puzzled!
Thanks!
Comments
-
That is odd. Can you post some screenshots?
Has the sheet ever been called "STREET Drug Seizures"?
-
It is possible it was named that at one time. I had "saved as new" and then renamed the sheets. I deleted those and just have the 2 sheets now. Is it possible it could be a fluke? The formula is working great when data is put in the Drug Seizure sheet, but the sheet name in the formula is incorrect.
I hope you can see it in my screen shot.
Thanks!
-
When you "Saved as New", were the formulas already there?
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!