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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives