Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
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
Was the new master sheet created in the same process as the sheets referencing it?
@Paul Newcome hello! Thank you for responding. Yes, they are all in the same folder.
I hope you're well and safe!
Ensure the correct connections are to the right sheet(s) using the Sheet 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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
@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?
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
