讨论
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…","categoryID":343,"dateInserted":"2022-11-29T18:07:02+00:00","dateUpdated":null,"dateLastComment":"2022-12-02T12:12:33+00:00","insertUserID":146366,"insertUser":{"userID":146366,"name":"DylBlake","url":"https:\/\/community.smartsheet.com\/profile\/DylBlake","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!DYDmgxui02s!3ODn__uYCfs!1PluHPngbi2","dateLastActive":"2022-12-27T21:57:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-06T23:21:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":106,"score":null,"hot":3339728975,"url":"https:\/\/community.smartsheet.com\/discussion\/98223\/control-center-cross-sheet-references","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98223\/control-center-cross-sheet-references","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-12-02T12:12:33+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":466,"urlcode":"control-center","name":"Control Center"}],"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}]},{"discussionID":90736,"type":"question","name":"Do group admins have to be in a group?","excerpt":"Hey there, I have made groups that I want to continue to manage, but I do not want to be a member of the group. Smartsheet seems to add the group admin by default and when I delete myself from a group, I reappear. For example, I want to make and manage an HR group, but I am not in HR. However, since I am the group admin, I…","categoryID":321,"dateInserted":"2022-05-03T19:34:44+00:00","dateUpdated":null,"dateLastComment":"2022-11-04T03:39:06+00:00","insertUserID":146366,"insertUser":{"userID":146366,"name":"DylBlake","url":"https:\/\/community.smartsheet.com\/profile\/DylBlake","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!DYDmgxui02s!3ODn__uYCfs!1PluHPngbi2","dateLastActive":"2022-12-27T21:57:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154331,"lastUser":{"userID":154331,"name":"sorokti","title":"","url":"https:\/\/community.smartsheet.com\/profile\/sorokti","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-05T13:05:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":273,"score":null,"hot":3319142030,"url":"https:\/\/community.smartsheet.com\/discussion\/90736\/do-group-admins-have-to-be-in-a-group","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/90736\/do-group-admins-have-to-be-in-a-group","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-05-04T13:27:57+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}],"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}]},{"discussionID":89426,"type":"question","name":"Open a Hyperlink In Excel App","excerpt":"I have a sheet with a SharePoint link to an Excel file in a cell. When I click on that link, it opens by default in the Excel online app. Is there a way to change the default so that it opens in Excel's desktop version?","categoryID":343,"dateInserted":"2022-03-25T20:59:46+00:00","dateUpdated":"2022-06-14T14:39:20+00:00","dateLastComment":"2022-03-27T06:14:26+00:00","insertUserID":146366,"insertUser":{"userID":146366,"name":"DylBlake","url":"https:\/\/community.smartsheet.com\/profile\/DylBlake","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!DYDmgxui02s!3ODn__uYCfs!1PluHPngbi2","dateLastActive":"2022-12-27T21:57:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":137040,"lastUser":{"userID":137040,"name":"Gia Thinh","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Gia%20Thinh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pXMt6Y5Kqjs!ZHDtmZp0Yms!Dwma-t47hzh","dateLastActive":"2023-05-17T00:10:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":672,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/89426\/open-a-hyperlink-in-excel-app","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/89426\/open-a-hyperlink-in-excel-app","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-03-27T06:14:26+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":331,"urlcode":"hyperlink","name":"hyperlink"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":false,"noCheckboxes":true}">
