easier references to other sheets
Hi all,
I prefer to use references of the form {sheet_name Range 1} rather than using the "link from cell in other sheet..." because the formula can be copied to another cell where trying to copy the direct-linked cell only copies the value, not the link. If I have a lot of cells all linked to a particular cell in another sheet, it's easier to use the formula version.
But..I don't get the prompt to select the reference unless I'm actually entering a formula. If I just type "=" into a cell, it knows I'm starting to type a formula but I don't get anything that allows me to reference a cell in another sheet unless I do something like "=sum(" at which point I get the help bubble for SUM which has the link-to-a-reference function. Once I make the link, I have something like "=SUM({sheet_name Range 1})" - then I can get rid of the SUM or just leave it.
So, the request is: as soon as I type "=" or even "{" give me a pop-up that starts the linking process instead of making me use the "=SUM(" workaround.
thanks!
Tags:
Categories
2023-05-05T05:43:47.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":105956,"type":"idea","name":"Feature Request - Dashboard Line Chart Colour Change","excerpt":"Good Morning, Firstly, the rebrand of the dashboards is fantastic - I had raised this as a feature request late last year and am so excited to use the new background colours and widget colours. Really good - thank you and thank you for listening to user requests :) I do have a further request if I may? On a line chart, the…","categoryID":349,"dateInserted":"2023-06-02T15:04:42+00:00","dateUpdated":"2023-06-02T15:51:17+00:00","dateLastComment":"2023-06-02T16:25:28+00:00","insertUserID":155892,"insertUser":{"userID":155892,"name":"bhiggins","url":"https:\/\/community.smartsheet.com\/profile\/bhiggins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-02T15:01:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":150051,"lastUser":{"userID":150051,"name":"DebRichardson","title":"Senior Administrative Assistant for the Office of Research Operations","url":"https:\/\/community.smartsheet.com\/profile\/DebRichardson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nB5UV6VYA5H58.png","dateLastActive":"2023-06-02T16:26:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":17,"score":2,"hot":3371442610,"url":"https:\/\/community.smartsheet.com\/discussion\/105956\/feature-request-dashboard-line-chart-colour-change","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105956\/feature-request-dashboard-line-chart-colour-change","format":"Rich","tagIDs":[292,363],"lastPost":{"discussionID":105956,"commentID":378599,"name":"Re: Feature Request - Dashboard Line Chart Colour Change","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378599#Comment_378599","dateInserted":"2023-06-02T16:25:28+00:00","insertUserID":150051,"insertUser":{"userID":150051,"name":"DebRichardson","title":"Senior Administrative Assistant for the Office of Research Operations","url":"https:\/\/community.smartsheet.com\/profile\/DebRichardson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nB5UV6VYA5H58.png","dateLastActive":"2023-06-02T16:26:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":105941,"type":"idea","name":"Separate reply-to email address for auto emails","excerpt":"Hello, I'd like to vote for the feature of a separate reply-to email address when setting up auto emails. I'm the owner of a large number of sheets, and despite it not necessarily being a problem that emails appear to come from me, i'm having a huge issue with the large number of replies i receive. Despite adding text in…","categoryID":349,"dateInserted":"2023-06-02T11:25:15+00:00","dateUpdated":"2023-06-02T11:47:43+00:00","dateLastComment":"2023-06-02T11:25:15+00:00","insertUserID":158282,"insertUser":{"userID":158282,"name":"Sophie C","url":"https:\/\/community.smartsheet.com\/profile\/Sophie%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-02T11:55:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":158282,"lastUser":{"userID":158282,"name":"Sophie C","url":"https:\/\/community.smartsheet.com\/profile\/Sophie%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-02T11:55:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":23,"score":1,"hot":3371411878,"url":"https:\/\/community.smartsheet.com\/discussion\/105941\/separate-reply-to-email-address-for-auto-emails","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105941\/separate-reply-to-email-address-for-auto-emails","format":"Rich","tagIDs":[334,363,510],"lastPost":{"discussionID":105941,"name":"Separate reply-to email address for auto emails","url":"https:\/\/community.smartsheet.com\/discussion\/105941\/separate-reply-to-email-address-for-auto-emails","dateInserted":"2023-06-02T11:25:15+00:00","insertUserID":158282,"insertUser":{"userID":158282,"name":"Sophie C","url":"https:\/\/community.smartsheet.com\/profile\/Sophie%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-02T11:55:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]},{"discussionID":105939,"type":"idea","name":"Admin Centre - multiple admins","excerpt":"Allow more than one user the ability to administer the admin centre. It is common for enterprise clients to have more than one administrator, therefore this creates bottlenecks in user management tasks, if that one user is busy or on annual leave.","categoryID":349,"dateInserted":"2023-06-02T10:50:44+00:00","dateUpdated":null,"dateLastComment":"2023-06-02T11:21:21+00:00","insertUserID":139581,"insertUser":{"userID":139581,"name":"darkmatter","url":"https:\/\/community.smartsheet.com\/profile\/darkmatter","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!XHPS3zzuBP4!m3DRfwiLWvQ!vLAErbBT_f5","dateLastActive":"2023-06-02T10:47:50+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-06-02T16:20:39+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":17,"score":1,"hot":3371408825,"url":"https:\/\/community.smartsheet.com\/discussion\/105939\/admin-centre-multiple-admins","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105939\/admin-centre-multiple-admins","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":105939,"commentID":378498,"name":"Re: Admin Centre - multiple admins","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378498#Comment_378498","dateInserted":"2023-06-02T11:21:21+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-06-02T16:20:39+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]}],"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
