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!