Copy References from one sheet to another, individual or bulk. + add multiple references

heyjay

1. How do I copy an existing reference from one of my sheet to another existing sheet?
2. How do I add multiple references without re opening the reference manager? It always closes.

https://community.smartsheet.com/discussion/comment/414050#Comment_414050

AravindGP

Hi @heyjay

1 is still not available as a feature

2 A reference gets auto added to the reference manager when you enter it as part of a formula by clicking on the "Reference another sheet" link during formula creation. You don't need to pre-create the references through reference manager before adding your cross sheet formulas

heyjay

https://community.smartsheet.com/discussion/comment/414162#Comment_414162

1. A
2. I already know the references that I will use. I have a prepared formula, I dont want to go and re open that reference manager everytime. I want to be able to add everything once.

AravindGP

Hi @heyjay

Unfortunately, there's no other way at the moment.

Andrée Starå

Hi @heyjay

I hope you're well and safe!

Unfortunately, it's not possible to do either now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Werner Wassermann

Hi @heyjay

We've included this feature in our Mission Control App (among many others) which exposes all references in the form of text which can be copied from one sheet and ported to numerous other sheets. Feel free to get in touch if you'd like more info.

241016071733.png

241016071724.png

Werner Wassermann | BEng |

Head of Innovation & Architecture

werner@ atvantage. co. za | www. rocketsolutions. co. za