Cell linking

Discussion List

When I open the Sheet Reference Manager it does not show any cell links. In the cell linking help articles I did not find any statement that the Sheet Reference Manager…","categoryID":321,"dateInserted":"2023-06-15T16:54:24+00:00","dateUpdated":null,"dateLastComment":"2023-06-19T17:31:50+00:00","insertUserID":162031,"insertUser":{"userID":162031,"name":"KimCole","title":"PMO Admin","url":"https:\/\/community.smartsheet.com\/profile\/KimCole","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ngMovzvTFoo!ZVkrGfPka7o!v96hQppUc9Y","dateLastActive":"2023-08-19T17:48:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":162031,"lastUser":{"userID":162031,"name":"KimCole","title":"PMO Admin","url":"https:\/\/community.smartsheet.com\/profile\/KimCole","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ngMovzvTFoo!ZVkrGfPka7o!v96hQppUc9Y","dateLastActive":"2023-08-19T17:48:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":70,"score":null,"hot":3374045774,"url":"https:\/\/community.smartsheet.com\/discussion\/106506\/managing-outbound-cell-links-entire-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106506\/managing-outbound-cell-links-entire-sheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-16T13:57: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":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":106555,"type":"question","name":"Formula that counts the total of red dot symbols in my status column","excerpt":"Hi everyone, I have a project plan with several rows. There's a STATUS column in which traffic lights colours (gray, green, yellow and red) appear depending on the closeness of the task to its deadline. In another sheet, I'd like to link a cell to the STATUS column and use a formula that counts how many red dots there are…","categoryID":322,"dateInserted":"2023-06-16T15:55:25+00:00","dateUpdated":null,"dateLastComment":"2023-06-16T16:50:57+00:00","insertUserID":103656,"insertUser":{"userID":103656,"name":"axelrodo","url":"https:\/\/community.smartsheet.com\/profile\/axelrodo","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5OHAuRriZn4!!NReNPAq4zpH","dateLastActive":"2023-08-16T03:55:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-20T05:10:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":82,"score":null,"hot":3373867582,"url":"https:\/\/community.smartsheet.com\/discussion\/106555\/formula-that-counts-the-total-of-red-dot-symbols-in-my-status-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106555\/formula-that-counts-the-total-of-red-dot-symbols-in-my-status-column","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T08:13:55+00:00","dateAnswered":"2023-06-16T15:59:27+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":17781,"type":"discussion","name":"Basic A\/P and A\/R payment tracker","excerpt":"We're a property management company with a construction arm. Our construction is basic and requires us simply to track Owner\/Address\/Date of approval\/Job number (which we create)\/Contractor's Bid\/Change orders\/Payments to Contractor\/Balance to contractor\/Our Bid\/Change Orders\/Payments to us\/Balance due us\/A\/R for cash paid…","categoryID":322,"dateInserted":"2018-01-15T13:23:15+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-06-15T14:13:39+00:00","insertUserID":34641,"insertUser":{"userID":34641,"name":"RRABruce","url":"https:\/\/community.smartsheet.com\/profile\/RRABruce","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-01-15T12:59:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162416,"lastUser":{"userID":162416,"name":"JGould","title":"James Gould","url":"https:\/\/community.smartsheet.com\/profile\/JGould","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-06T12:39:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":460,"score":null,"hot":3202862814,"url":"https:\/\/community.smartsheet.com\/discussion\/17781\/basic-a-p-and-a-r-payment-tracker","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/17781\/basic-a-p-and-a-r-payment-tracker","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-01\/e3\/0b\/e30bf80d64efe60f40bc29785a298c4f.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"contractor sheet.JPG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":215,"urlcode":"Templates","name":"Templates"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":247,"urlcode":"Contacts","name":"Contacts"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":266,"urlcode":"Real Estate","name":"Real Estate"},{"tagID":271,"urlcode":"Services","name":"Services"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":96799,"type":"question","name":"Can you cell-link within the same sheet?","excerpt":"My team is tracking product development for a project and we want to be able to reference multiple rows within the same sheet. For example, in row 20 we want to have a column labelled \"Refer To\" and then in the cell, have a link that takes the user to row 100, 140, or 170. I know you can cell-link to other sheets in a…","categoryID":321,"dateInserted":"2022-10-19T18:18:48+00:00","dateUpdated":null,"dateLastComment":"2023-06-15T12:58:09+00:00","insertUserID":148706,"insertUser":{"userID":148706,"name":"Bradhickswa","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Bradhickswa","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!AuHRX9yKuf0!3hlSP6CUF7s!8dWYTxFWd_v","dateLastActive":"2023-04-26T18:07:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":157221,"lastUser":{"userID":157221,"name":"yourfriendthedog","url":"https:\/\/community.smartsheet.com\/profile\/yourfriendthedog","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!8pjetwqR-zc!gjtRH-ScuTU!jSb_wMTshAs","dateLastActive":"2023-06-15T12:56:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":359,"score":null,"hot":3353041617,"url":"https:\/\/community.smartsheet.com\/discussion\/96799\/can-you-cell-link-within-the-same-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96799\/can-you-cell-link-within-the-same-sheet","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-19T20:20:00+00:00","dateAnswered":"2022-10-19T19:22:53+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":106230,"type":"question","name":"Array and Index Training Records to pull who needs to complete something within a date range","excerpt":"I manage training records and am creating a dashboard to manage who needs to complete a training. I have a master sheet with the employee name, and a reference column to them completing the training and when it is due I then have a calculation sheet to count how many people fall within that date range =COUNTIFS({HiPot…","categoryID":322,"dateInserted":"2023-06-08T19:43:06+00:00","dateUpdated":"2023-06-08T19:45:18+00:00","dateLastComment":"2023-06-13T14:25:11+00:00","insertUserID":162219,"insertUser":{"userID":162219,"name":"Ellyn","url":"https:\/\/community.smartsheet.com\/profile\/Ellyn","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T19:44:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162219,"lastUserID":162219,"lastUser":{"userID":162219,"name":"Ellyn","url":"https:\/\/community.smartsheet.com\/profile\/Ellyn","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T19:44:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":54,"score":null,"hot":3372920897,"url":"https:\/\/community.smartsheet.com\/discussion\/106230\/array-and-index-training-records-to-pull-who-needs-to-complete-something-within-a-date-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106230\/array-and-index-training-records-to-pull-who-needs-to-complete-something-within-a-date-range","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/CFEWJG06FRUC\/1-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"1.PNG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-09T05:53:22+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":105972,"type":"question","name":"Multiple cells locked to single formula in same column","excerpt":"I'm relatively new to Smartsheet and use it as a tertiary tool, so apologies if this is a 'basic' question. What I want is to tweak a formula on one row of a column and have it apply all other rows that reference that cell in the same column so I don't have to copy the tweaked @row + Parent, Children, or Ancestors…","categoryID":322,"dateInserted":"2023-06-02T18:29:22+00:00","dateUpdated":"2023-06-02T18:32:12+00:00","dateLastComment":"2023-06-12T18:31:12+00:00","insertUserID":162037,"insertUser":{"userID":162037,"name":"idenroc","url":"https:\/\/community.smartsheet.com\/profile\/idenroc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-12T23:31:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162037,"lastUserID":162037,"lastUser":{"userID":162037,"name":"idenroc","url":"https:\/\/community.smartsheet.com\/profile\/idenroc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-12T23:31:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":108,"score":null,"hot":3372330034,"url":"https:\/\/community.smartsheet.com\/discussion\/105972\/multiple-cells-locked-to-single-formula-in-same-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105972\/multiple-cells-locked-to-single-formula-in-same-column","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-12T18:31:14+00:00","dateAnswered":"2023-06-12T18:23:15+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":true,"noCheckboxes":false}">