"Save as New" folder not saving cross-sheet column references

Michelle Fayed

Good afternoon,

Thank you in advance for your help, time and attention.

I created a workspace with folders that contain template I need to save as new annually. I cannot save as new the workspace because there are too many files in it. When I did that today, the cross-sheet references in all of the sheets within the folder did not save the reference. When saving as new (please see the attach picture) I made sure to have these sheet reference the newly created master sheet. I've attached a photo of the columns now giving me an error. Help please? This will take HOURS if not days to correct. TIA

Paul Newcome

Was the new master sheet created in the same process as the sheets referencing it?

Michelle Fayed

@Paul Newcome hello! Thank you for responding. Yes, they are all in the same folder.

Andrée Starå

Hi @Michelle Fayed

I hope you're well and safe!

Ensure the correct connections are to the right sheet(s) using the Sheet Reference Manager.

https://help.smartsheet.com/articles/2482646-view-modify-delete-cross-sheet-references-formulas#toc-edit-in-the-reference-manager

Were all connections correct?

I hope that helps!

Be safe, and have a fantastic week!

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!

Michelle Fayed

@Andrée Starå That was very helpful. Follow up question. If I update the references with the method you showed me, how can I copy and pasta the formulas into all of the other sheets? When I update the formula, and select another sheet to paste it in, it gives me erorr messages?

Andrée Starå

@Michelle Fayed

Excellent!

Happy to help!

You'd have to create each reference in the corresponding sheet.

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