Smartsheet Control Center Auto Provision... Cross Sheet References Not Loading?

For the Smartsheet community online:
I've made a valuable discovery regarding Index(Match()) Cross Sheet References and all others when using Control Center in Smartsheet. If you're experiencing issues where these references don't work when creating "Children" from a "Parent" folder, here's a solution to save you time and frustration:
- Save your workspace as "New" to create a blueprint source folder.
- Add data to at least one cell in each of the sheets.
- Save the workspace again.
- Delete the data you added earlier.
- Now, use this workspace in Smartsheet Control Center Blueprint.
Magically, your Cross Sheet References should work smoothly. Remember, when automating digital asset creation, it's a good practice to have at least one cell of "data" in the Parent Asset. This rule applies not only to Smartsheet but also to tools like ArcGIS and others.
CEO | Skyway Consulting Co.
Does your Dashboard need a map that updates from Smartsheet Data?
We pioneered 101+ ways to add a map to a Smartsheet Dashboard.
Smartsheet and GIS Integrations
→ Explore Smartsheet Maps (ArcGIS)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 432 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives