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
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives