Control Centre: new profile data is not cell-linking in the summary sheet
I have added 3 data sets via global updates, the columns appeared in my summary sheet automatically as usual but the data itself isn't auto cell-linking like it has previously.
I have made sure the column types are dates as all the data is a date. I have removed all column formulas from the summary sheet as requested.
I have spoken to the IT/ help team but they take ages to get back and aren't very clear. Frustrating as I have added some new profile data recently and didn't have an issue! I'm not sure what has changed.
Anyone have any suggestions?
Answers
-
Kleerfyre ✭✭✭✭✭✭
Have you checked the logs in Control Center for any errors on the newly created projects using this new data? Does the new columns have a cell in the Summary section of your template to link to?
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
Matt Johnson ✭✭✭✭✭✭
Hi@Brucey
Here's a confirmed fix but depending on how many projects you have it might not be a perfect fit as it has to be done 1 project at a time.
Go to the list of projects in Control Center and click the edit pencil on the far right. Then, in the edit screen, there is an option on the lower right called "Update Reporting". Click that and the cell link(s) should appear in the Summary Rollup.
I hope that helps.
Matt
-
Brucey ✭✭✭✭
I am getting the following error:
Summary Reporting: fail to update cell links to reporting sheet 'RCD Development Projects Summary'. Error message: An unexpected error has occurred. Please contact the Support team athttps://help.smartsheet.com/contactfor assistance.(4000)
and yes - when I carried out the global update, the cells (rows really) were added to the template projects (in the project plan).
@Matt Johnsonthe above error occurs when I try to update the programme and individual projects!
Thanks both,
-
Kleerfyre ✭✭✭✭✭✭
Are you trying to link data from the start date and finish date columns? If so, you can't do that in Control Center. You will need to create helper columns for those dates.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
Brucey ✭✭✭✭
@KleerfyreI'm not linking them directly, I have my profile data in a summary above the the Gantt data, so nothing comes directly from them, but the summary data takes it from the Finish column using : =IFERROR(DATEONLY(Finish$42), "") + ""
Is that what you mean by helper column?
-
Kleerfyre ✭✭✭✭✭✭
And if you do that with linking, you will always get the error. It doesn't matter where that comes from, it matters if you make your project summary link any cell in start or finish date column. You cannot link those without getting an error. I went through that and it took me forever to figure that out. When I did, I created helper columns that any date cell will link to in the summary section of the project template.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
Brucey ✭✭✭✭
It is working for every other column! my 'Helper'/ summary columns looks at the finish date column. So I am not using any start/ finish column to cell link directly to the summary sheets.
也许你能提供一个例子,你意味着什么n by helper column? I'm using a task/ summary column instead of directly linking as you said.
I had Cheetah Transformations (Smartsheet approved consultant) help me set it up and they wrote all these formulas and everything else works perfectly. They believe it's a technical error.
-
Kleerfyre ✭✭✭✭✭✭
Look at this screen shot. It shows what I am talking about. Control Center doesn't like it when you try doing any links to system columns.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
Kleerfyre ✭✭✭✭✭✭
And if you had a consultant help with the set up, I would suggest you get with them first on fixing the issue. They know what they built and will be able to help pinpoint the issue quicker. I would always go to them first seeing that each person that builds a Program in Control Center will know what they did to make it work for that specific case.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
Brucey ✭✭✭✭
I'm doing the same - using this 'role' column. All the other pieces of information eg - Baseline start, Project Type all link through.
-
Brucey ✭✭✭✭
Okay I'll ask them again, it's a tricky one.
Appreciate the help !
Categories
I'll answer what I can and shout out to @Brian_Richardson<\/a> for back up. <\/p> #1 Report Filters- To my knowledge there isn't a direct Report Filter update however I wondered if the column was a dropdown list - if so, Bridge can update dropdown lists and if the filter was set to select all it made me wonder if the filter would pick it up new selections. (Datashuttle also updates dropdown lists if this method works)<\/p> #2 I've had problems with a slow sheet erroring out in Bridge. The sheet was massive and Bridge would time-out. Bridge did not help this sheet (it might have been too large for anything to help)<\/p> #3 -I don't have any experience with Control Center, so sorry, I can't answer those questions<\/p> My fav Bridge solutions?<\/p> -Capturing Approver Names in approval workflows<\/p> -Adding rows - same sheet, different sheets, Child rows to Parents, On a weekly cadence, Adding New rows of acquired data to a status update sheet which feeds into a dashboard report<\/p> -Translating Employee Ideas from their native tongue to English<\/p> -Checking FedEx Tracking Status on a sheet's worth of shipments<\/p> I hope this helps<\/p> Kelly<\/p>"},{"commentID":373322,"body":" Hey @Julie Fortney<\/a> !<\/p> @Kelly Moore<\/a> thanks for the shout out :-) but I'm not sure I can help more than what's already been posted. <\/p> @Julie Fortney<\/a> in general Bridge is an API tool. You can setup multi-branched workflows in Bridge with pre-set API calls and utilities. You can also do custom HTTP calls to any API that you have access to in the cloud. So anything you can do with API calls you can do with Bridge. It also, importantly, allows you to run Javascript code using the results of your API calls, and to trigger workflows on changes to Smartsheet content or on any other webhook that you can receive from other tools.<\/p> There's a fair amount of Smartsheet API methods that are prebuilt into Bridge, but not all of them. So if you're looking at the Bridge documentation for Smartsheet<\/a> integrations and not finding what you need, you can also look at the Smartsheet API documentation<\/a> to see if there's something there to help you out. If you find an API method to use that's not already pre-built as an integration, then you can use the Custom HTTP Call step to directly call the API. You just have to provide the Smartsheet API with an API token, which you can assign to yourself in your Personal Settings.<\/p> It looks like your specific questions were answered pretty comprehensively by Kelly and Samuel but here's my 2c:<\/p> At Iron Mountain we use Bridge for a variety of use cases, here's the most effective ones:<\/p> Hope that helps (a little). If you're trying to figure out whether you'll find Bridge useful, my best advice would be to decide how much integration you want to do. That's really what Bridge is for IMHO. You can<\/em> use Bridge to do more advanced workflows in Smartsheet but it can be a little tricky, often it's easier to leverage the prebuilt addons like Data Mesh and Data Shuttle in combination with automations to achieve what you're looking for. That said, Bridge is quite powerful and can certainly take your Smartsheet setup to the next level.<\/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":369,"urlcode":"bridge-by-smartsheet","name":"Bridge"}]},{"discussionID":108771,"type":"question","name":"Has Smartsheet improved the Workapps notification functionality?","excerpt":"While looking at a Smartsheet Workapp today, I noticed the text highlighted below. It says: \"Automation: You can create automated workflows in Smartsheet to alert people in your app. Learn more\" I was excited to see this because I don't use the Workapp tool since it lacks a way to A) notify users of notifications within…","snippet":"While looking at a Smartsheet Workapp today, I noticed the text highlighted below. It says: \"Automation: You can create automated workflows in Smartsheet to alert people in your…","categoryID":343,"dateInserted":"2023-08-10T01:25:46+00:00","dateUpdated":"2023-08-10T07:34:18+00:00","dateLastComment":"2023-08-10T13:12:38+00:00","insertUserID":13526,"insertUser":{"userID":13526,"name":"Marc Shecter","url":"https:\/\/community.smartsheet.com\/profile\/Marc%20Shecter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/7MDG7HO742ML\/nHOVUT0FAH0M1.jpg","dateLastActive":"2023-08-10T15:38:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":91566,"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-10T18:34:53+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":20,"score":null,"hot":3383304504,"url":"https:\/\/community.smartsheet.com\/discussion\/108771\/has-smartsheet-improved-the-workapps-notification-functionality","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108771\/has-smartsheet-improved-the-workapps-notification-functionality","format":"Rich","tagIDs":[371,510,514],"lastPost":{"discussionID":108771,"commentID":389996,"name":"Re: Has Smartsheet improved the Workapps notification functionality?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/389996#Comment_389996","dateInserted":"2023-08-10T13:12:38+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-10T18:34:53+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\/C4YA4UIUZFSF\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-10T15:39:24+00:00","dateAnswered":"2023-08-10T13:12:38+00:00","acceptedAnswers":[{"commentID":389996,"body":" Hi @Marc Shecter<\/a> <\/p> The prompt here is to help Workapp Builders use automations in the underlying Smartsheet sheet to send out notifications. There currently isn't a way to build an automation directly in the Workapp, as you noted. I see you created an Idea Post<\/a> around this, thank you!<\/p> For your B), you could add the URL to the Workapp in the body text of the notification if that helps.<\/p> Cheers,<\/p> Genevieve<\/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":371,"urlcode":"WorkApps","name":"WorkApps"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"},{"tagID":514,"urlcode":"slack-notifications","name":"Slack Notifications"}]},{"discussionID":81825,"type":"question","name":"Control Center profile data","excerpt":"Hello everyone, Do you know what is the difference between \"one time write\" and \"editable value\" when we configure profile data ? I can't find information on this parameter. Thank you for your help, Have a nice day, Corentin","snippet":"Hello everyone, Do you know what is the difference between \"one time write\" and \"editable value\" when we configure profile data ? I can't find information on this parameter. Thank…","categoryID":343,"dateInserted":"2021-08-04T15:22:08+00:00","dateUpdated":"2022-06-14T14:38:22+00:00","dateLastComment":"2023-08-10T00:13:11+00:00","insertUserID":120110,"insertUser":{"userID":120110,"name":"Corentin Dal Farra","url":"https:\/\/community.smartsheet.com\/profile\/Corentin%20Dal%20Farra","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nrtVvwdzHTo!U5VVnwNbQ4Q!QK6RQ3smzIb","dateLastActive":"2022-06-21T12:25:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":148703,"lastUser":{"userID":148703,"name":"Kayla Q","url":"https:\/\/community.smartsheet.com\/profile\/Kayla%20Q","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!A6O0x6U5B7g!D_Erg-_Cvns!j14wSxJ9_1x","dateLastActive":"2023-08-09T23:51:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":484,"score":null,"hot":3319718719,"url":"https:\/\/community.smartsheet.com\/discussion\/81825\/control-center-profile-data","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/81825\/control-center-profile-data","format":"Rich","lastPost":{"discussionID":81825,"commentID":389941,"name":"Re: Control Center profile data","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/389941#Comment_389941","dateInserted":"2023-08-10T00:13:11+00:00","insertUserID":148703,"insertUser":{"userID":148703,"name":"Kayla Q","url":"https:\/\/community.smartsheet.com\/profile\/Kayla%20Q","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!A6O0x6U5B7g!D_Erg-_Cvns!j14wSxJ9_1x","dateLastActive":"2023-08-09T23:51:00+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/HU1SUMAZFTJO\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-08-06T07:31:01+00:00","dateAnswered":"2021-08-05T17:11:20+00:00","acceptedAnswers":[{"commentID":300485,"body":" Hey @Corentin Dal Farra<\/a>,<\/p> The \"One Time Write\" behavior will copy the value from the cell in the intake to the Profile Data<\/a> cell in the project sheet(s); this allows collaborators to update the value within the project sheets unlike the \"Cell Link\" option.<\/p> Essentially, \"Editable Value\" behavior is the same as \"One Time Write\" but when you Edit Project Information in Smartsheet Control Center you will be able to update the value and ensure that it is updated in all sheets where the Profile Data appears: <\/p>