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

Ward.Hively
Ward.Hively ✭✭✭✭
edited 10/16/23 in Best Practice

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:

  1. Save your workspace as "New" to create a blueprint source folder.
  2. Add data to at least one cell in each of the sheets.
  3. Save the workspace again.
  4. Delete the data you added earlier.
  5. 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.

Ward Hively

President and Chief Consultant

🌉Skyway Consulting Co.🌉

Need Smartsheet Help? Schedule a complementary consultation click SCHEDULE

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

ArcGIS Online

✅ Arc Py

✅ Smartsheet Advanced

✅ Manage your GIS records from Dynamic View, Sheet or Report

✅ No Code (Limited Applications Apply)

Website: https://skywayconsultingco.com

LinkedIn: (49) Ward Hively | LinkedIn