Why do i have to add data in range to get cross-sheet reference to copy?
I have a template folder that uses multiple sheets . One of which has a cross reference to another sheet that will be populated when people fill out forms. This reference is used in a formula that fills in values for half the sheet.
However, when I save as new for a new instance of this folder (It is necessary to create a new one every time we go to production with a new product), the cross-sheet reference is deleting. The only way for me to get it is to prefill a dummy value in the reference range in my template.
I imagine this is similar to why it won't let you create the initial reference in the sheet with empty range(which I also think is bizarre because all but 1 cell can be empty), but I still don't want to have to create messy dummy data in order to have my sheet function.
Does anyone else deal with this? Or have a workaround aside from inputting a dummy value?
Answers
-
Hi @Mdoban
You're correct, cross-sheet references cannot be created on an empty column. This means in your case, when the sheet is copied, the copy action cannot create the cross-sheet references to a blank/empty sheet.
I don't have another suggestion for you, other than inputting test data. Please submit your feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives