Referencing other sheets

CherylAK ✭✭✭✭
edited 12/09/19 in Formulas and Functions

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 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!





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!