Control Center & Cross-Sheet References
Hello all,
This is my first attempt at SCC provisioning of sheets and I ran into my first problem. There are three sheets in the blueprint -> Sheets A1, A2, & B. B pulls in data from sheet A1 and A2 via cross sheet references (index/match so I can reference by a key value in case rows move around in A1 and/or A2). When I provision the project, the provisioned B is still referencing A1 and A2 sheets in the blueprint folder - not the provisioned A1 and A2 for the project.
Is there a way to have the blueprint manage the references so that the provisioned B sheet references the provisioned A1 & A2? I need the ability to reference by a key value as the rows in A1 and A2 will need to change as people work within them.
Answers
-
Andrée Starå ✭✭✭✭✭✭I hope you're well and safe!
Yes, but you need to include them in the Blueprint. (go through and add them in the Blueprint builder)
Make sense?
Did that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
✅了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Categories
Glad to hear that it worked for your present use-case. <\/p>
✅Remember! <\/strong>Did my post help or answer your question or solve your problem? Please help the Community by <\/em>marking it as the accepted answer\/helpful<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":109291,"type":"question","name":"How do I make a global sheet\/report\/dashboard name change","excerpt":"I use Control Center to provision new projects. How do I globally change sheet\/report\/dashboard names' suffix after a project has been provisioned and is underway? For example, if the suffix was \"Enterprise Business Unit\", and now I want it to be \"Enterprise BU\".","snippet":"I use Control Center to provision new projects. How do I globally change sheet\/report\/dashboard names' suffix after a project has been provisioned and is underway? For example, if…","categoryID":343,"dateInserted":"2023-08-22T18:03:46+00:00","dateUpdated":null,"dateLastComment":"2023-08-22T19:36:01+00:00","insertUserID":149249,"insertUser":{"userID":149249,"name":"ShannonTozier","url":"https:\/\/community.smartsheet.com\/profile\/ShannonTozier","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pxvQ6TiroDw!HCDQ32y7iGY!YRwAmRkBQEG","dateLastActive":"2023-08-22T19:51:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-23T01:18:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":20,"score":null,"hot":3385460987,"url":"https:\/\/community.smartsheet.com\/discussion\/109291\/how-do-i-make-a-global-sheet-report-dashboard-name-change","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109291\/how-do-i-make-a-global-sheet-report-dashboard-name-change","format":"Rich","tagIDs":[466,582],"lastPost":{"discussionID":109291,"commentID":391983,"name":"Re: How do I make a global sheet\/report\/dashboard name change","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391983#Comment_391983","dateInserted":"2023-08-22T19:36:01+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-23T01:18:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-22T19:51:29+00:00","dateAnswered":"2023-08-22T19:36:01+00:00","acceptedAnswers":[{"commentID":391983,"body":" There is no way to do that through Global Updates. You will need to either do it manually or through the API.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":466,"urlcode":"control-center","name":"Control Center"},{"tagID":582,"urlcode":"global-updates","name":"global updates"}]},{"discussionID":109130,"type":"question","name":"//www.santa-greenland.com/community/discussion/98223/\"Get Sheet\" in Bridge not working","excerpt":"Ok I scrubbed the forum and can't find an answer. I have Bridge workflow that calls \"Get Sheet\" twice. She image. The second is not providing an output, but the Run complete successfully. I specified the SheetID, I am the owner of that sheet.","snippet":"Ok I scrubbed the forum and can't find an answer. I have Bridge workflow that calls \"Get Sheet\" twice. She image. The second is not providing an output, but the Run complete…","categoryID":343,"dateInserted":"2023-08-18T02:50:31+00:00","dateUpdated":null,"dateLastComment":"2023-08-21T08:21:37+00:00","insertUserID":148386,"insertUser":{"userID":148386,"name":"dsmitts.jay","url":"https:\/\/community.smartsheet.com\/profile\/dsmitts.jay","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Asq033UutIg!DAu0A77Sx_w!NYd7SSBcGwv","dateLastActive":"2023-08-20T18:41:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-22T17:41:59+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":49,"score":null,"hot":3384936128,"url":"https:\/\/community.smartsheet.com\/discussion\/109130\/get-sheet-in-bridge-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109130\/get-sheet-in-bridge-not-working","format":"Rich","lastPost":{"discussionID":109130,"commentID":391563,"name":"Re: \"Get Sheet\" in Bridge not working","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391563#Comment_391563","dateInserted":"2023-08-21T08:21:37+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-22T17:41:59+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/2USQVMXJ1B6S\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-21T08:21:28+00:00","dateAnswered":"2023-08-18T16:40:11+00:00","acceptedAnswers":[{"commentID":391426,"body":"
