hyperlink
Discussion List
Open in New Tab \/ plugin mouse gesture) I see there is a similar request for hyperlinks in forms to be handled in this same fashion, or perhaps to allow the form…","categoryID":349,"dateInserted":"2022-07-19T19:04:32+00:00","dateUpdated":null,"dateLastComment":"2022-07-19T15:39:07+00:00","insertUserID":83406,"insertUser":{"userID":83406,"name":"Nahum","url":"https:\/\/community.smartsheet.com\/profile\/Nahum","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-19T19:04:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":112101,"lastUser":{"userID":112101,"name":"cbrucher","url":"https:\/\/community.smartsheet.com\/profile\/cbrucher","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!86vXt72zxP4!eiDU5y3VGGY!steIrAKZC6R","dateLastActive":"2022-09-06T19:39:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":153,"score":8,"hot":3316505619,"url":"https:\/\/community.smartsheet.com\/discussion\/93376\/allow-notification-hyperlinks-to-be-opened-in-new-tab-window","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93376\/allow-notification-hyperlinks-to-be-opened-in-new-tab-window","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":331,"urlcode":"hyperlink","name":"hyperlink"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":92677,"type":"idea","name":"Dynamic View: Hyperlinks","excerpt":"We currently build a hyperlink to a prefilled form using a formula and the row ID. But the biggest limitation on this is they do not function in Dynamic View. The end user has to copy\/past to get to the form.","categoryID":349,"dateInserted":"2022-06-27T13:41:50+00:00","dateUpdated":"2022-06-28T08:46:10+00:00","dateLastComment":"2022-06-27T13:41:50+00:00","insertUserID":129581,"insertUser":{"userID":129581,"name":"Sara Campbell","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20Campbell","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!htjdYU7s_ZY!nEDQn2ihiWQ!myC69gloCfY","dateLastActive":"2023-06-30T12:51:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":129581,"lastUser":{"userID":129581,"name":"Sara Campbell","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20Campbell","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!htjdYU7s_ZY!nEDQn2ihiWQ!myC69gloCfY","dateLastActive":"2023-06-30T12:51:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":226,"score":6,"hot":3312745080,"url":"https:\/\/community.smartsheet.com\/discussion\/92677\/dynamic-view-hyperlinks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92677\/dynamic-view-hyperlinks","format":"Rich","groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/G2A8BA3BHTVT\/hyperlink-greyed-out.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"hyperlink greyed out.jpg"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":331,"urlcode":"hyperlink","name":"hyperlink"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":92583,"type":"question","name":"Pasting hyperlinked text between smartsheets","excerpt":"I am trying to copy and paste hyperlinked text between smartsheets. All I am able to do is paste the text and not the hyperlink that was attached to the text. I have tried pasting special and that has not worked either. Thanks for any advice you may have!","categoryID":321,"dateInserted":"2022-06-23T19:00:28+00:00","dateUpdated":null,"dateLastComment":"2022-06-24T00:12:27+00:00","insertUserID":149399,"insertUser":{"userID":149399,"name":"oerthera","url":"https:\/\/community.smartsheet.com\/profile\/oerthera","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-14T14:46:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":145151,"lastUser":{"userID":145151,"name":"Mike TV","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20TV","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxaedq_6L-MOFFHnCvRUoauO8dJvnzqzFpP7VPvi=s96-c","dateLastActive":"2023-07-07T15:52:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":92,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/92583\/pasting-hyperlinked-text-between-smartsheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92583\/pasting-hyperlinked-text-between-smartsheets","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-24T00:10:17+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":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}]},{"discussionID":91509,"type":"question","name":"Auto-populate a form field with the result of a formula in the sheet.","excerpt":"I have my sheet set up so that when I click the generated URL, certain fields of the form that the URL leads to are auto-populated with values from the same row. My issue is that it seems like I can only auto-populate manually entered values and not values generated from column formulas. Is there a way to do this? Maybe I…","categoryID":322,"dateInserted":"2022-05-25T21:18:10+00:00","dateUpdated":null,"dateLastComment":"2022-06-01T13:04:39+00:00","insertUserID":127353,"insertUser":{"userID":127353,"name":"Shane Brown","url":"https:\/\/community.smartsheet.com\/profile\/Shane%20Brown","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xzFVcScPIPo!27NW_xN4Zvw!s4yCfQk0c6r","dateLastActive":"2023-03-07T21:00:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":127353,"lastUser":{"userID":127353,"name":"Shane Brown","url":"https:\/\/community.smartsheet.com\/profile\/Shane%20Brown","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xzFVcScPIPo!27NW_xN4Zvw!s4yCfQk0c6r","dateLastActive":"2023-03-07T21:00:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":409,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/91509\/auto-populate-a-form-field-with-the-result-of-a-formula-in-the-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91509\/auto-populate-a-form-field-with-the-result-of-a-formula-in-the-sheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-05-25T23:34:17+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":204,"urlcode":"Forms","name":"Forms"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":331,"urlcode":"hyperlink","name":"hyperlink"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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":91502,"type":"question","name":"Automatic Duration column calculation + Linked Dates, is this possible?","excerpt":"Is it possible to have a \"Duration\" column that automatically calculates duration days based on End Dates that are linked to another sheet? For context these are my 2 scenarios: One: My Start Dates are linked to another sheet, my End Dates are manually entered, and my Duration column automatically calculates total days.…","categoryID":322,"dateInserted":"2022-05-25T20:11:12+00:00","dateUpdated":null,"dateLastComment":"2022-05-26T13:14:38+00:00","insertUserID":145754,"insertUser":{"userID":145754,"name":"Cesar Fernandez","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Cesar%20Fernandez","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Umtmn4OncvM!A9Hn34uahXM!J-qdl6sKmFi","dateLastActive":"2022-06-16T21:04:46+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-07-08T12:30:08+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":266,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/91502\/automatic-duration-column-calculation-linked-dates-is-this-possible","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91502\/automatic-duration-column-calculation-linked-dates-is-this-possible","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-05-26T16:45:46+00:00","dateAnswered":"2022-05-26T13:14:38+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":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}]},{"discussionID":86660,"type":"question","name":"Create a Form with Auto Filled","excerpt":"I have a sheet (Sheet 1) that is my Master Project. Each project has to create subtask request for another department (within Sheet2) but a lot of information prefilled in Sheet 1 needs to be fulfilled into Sheet 2 when the request is made to that other department. Is there a way to create a form within Sheet 2, use the…","categoryID":321,"dateInserted":"2022-01-18T20:21:14+00:00","dateUpdated":null,"dateLastComment":"2022-05-12T13:42:23+00:00","insertUserID":143595,"insertUser":{"userID":143595,"name":"Mathieu Gaboury","url":"https:\/\/community.smartsheet.com\/profile\/Mathieu%20Gaboury","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-01-21T12:33:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":147952,"lastUser":{"userID":147952,"name":"juliebice","url":"https:\/\/community.smartsheet.com\/profile\/juliebice","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-05-12T13:37:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":556,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/86660\/create-a-form-with-auto-filled","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/86660\/create-a-form-with-auto-filled","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-01-18T20:41:50+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":204,"urlcode":"Forms","name":"Forms"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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}]},{"discussionID":90380,"type":"question","name":"Is it possible to add a link to a smartsheet item as view only?","excerpt":"I have one master sheet (my department overview) into which I want to add links to dashboards in multiple other workspaces (one per project). I have one row per project and it is very simple to right click, add hyperlink and choose smartsheet item, then simply select the workspace and dashboard for the project. However, I…","categoryID":322,"dateInserted":"2022-04-22T16:41:34+00:00","dateUpdated":null,"dateLastComment":"2022-04-25T16:41:25+00:00","insertUserID":146304,"insertUser":{"userID":146304,"name":"KPH","url":"https:\/\/community.smartsheet.com\/profile\/KPH","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-02T01:17:44+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-07-08T18:30:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":264,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/90380\/is-it-possible-to-add-a-link-to-a-smartsheet-item-as-view-only","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/90380\/is-it-possible-to-add-a-link-to-a-smartsheet-item-as-view-only","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-04-25T15:30:35+00:00","dateAnswered":"2022-04-23T08:45:11+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":292,"urlcode":"Dashboards","name":"Dashboards"},{"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}]},{"discussionID":89488,"type":"question","name":"Create a dynamic link to \"drill down\" to a source sheet from a report","excerpt":"I know there has to be a simple way to do this but I'm not finding it and I getting into crunch time on this project so, HELP! :) I have a sheet that has a bunch of projects on it. I am pulling a report to a tracking sheet that folks will use as a starting off point to look at project progress. Whenever I add a new project…","categoryID":322,"dateInserted":"2022-03-28T20:56:30+00:00","dateUpdated":null,"dateLastComment":"2022-03-31T12:25:01+00:00","insertUserID":145797,"insertUser":{"userID":145797,"name":"Freymish","url":"https:\/\/community.smartsheet.com\/profile\/Freymish","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/GZADH7ZBQ6P2\/nGJT84EVC70D8.jpg","dateLastActive":"2022-06-02T11:43:13+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-07-08T12:30:08+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":426,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/89488\/create-a-dynamic-link-to-drill-down-to-a-source-sheet-from-a-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/89488\/create-a-dynamic-link-to-drill-down-to-a-source-sheet-from-a-report","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-03-30T16:51:36+00:00","dateAnswered":"2022-03-30T15:29:32+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":265,"urlcode":"Reports","name":"Reports"},{"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":true,"noCheckboxes":false}">