Is it possible to have a column in a sheet serve as a reference to multiple other sheets?

Jamy Crum

Here is my scenario:

I am redesigning some of my template sets and dashboards but leaving the originals up and running at the same time. I created a sandbox environment (workspace) to do this in. Some of the new sheets use the same data and formulas. Copy and pasting the formulas sometimes required me to recreate the reference (not sure why). When I did that, it fixed the formula but then broke the original, probably because I decided to give the reference a relatable name rather than sticking with the original default names that smartsheet gave. However, when I go back to the original sheet and try to just fix the reference by deleting the original reference in the formula and then opening up the reference picker, selecting the same sheet and column does not show me the new reference name. Can the column getting referenced have multiple reference names and be different for every sheet referencing it? How does this work and what is best practice when it come to multiple sheets referencing the same thing to avoid the #INVALIDREF errors?

Thanks!

RossL

@Jamy Crum

Yes this is possible. My best example is I have a Holiday list and ref that list for all workday calculations. The ref name is going to be tied to the formula and not the ref sheet. so on sheet 1 if you pic a column in sheet 2 and call it XYZ then in sheet 3 if you pick the same column in sheet 2 you can name it ABC.

RossL

@Jamy Crum

Yes this is possible. My best example is I have a Holiday list and ref that list for all workday calculations. The ref name is going to be tied to the formula and not the ref sheet. so on sheet 1 if you pic a column in sheet 2 and call it XYZ then in sheet 3 if you pick the same column in sheet 2 you can name it ABC.

Jamy Crum

RossL

Thanks for the information.

That helps to clear things up for me.