hyperlink

Discussion List

Link to send…","categoryID":322,"dateInserted":"2021-01-30T16:55:14+00:00","dateUpdated":"2021-01-30T16:58:54+00:00","dateLastComment":"2021-02-01T07:20:20+00:00","insertUserID":127181,"insertUser":{"userID":127181,"name":"James Keuning","title":"","url":"https:\/\/community.smartsheet.com\/profile\/James%20Keuning","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-10T12:40:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":127181,"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-11T04:11:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":61,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/75517\/can-i-create-a-hyperlink-by-combining-text-strings-and-fielded-data-pretty-basic-parameter-work","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75517\/can-i-create-a-hyperlink-by-combining-text-strings-and-fielded-data-pretty-basic-parameter-work","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-02-01T07:20:20+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":75177,"type":"question","name":"Saving a folder of sheets with hyperlinks","excerpt":"Hi All, I have a folder full of sheets. Each time my company gets a new client I do a Save As and put all those sheets into that client's workspace. I have a checklist sheet in this folder that has hyperlinks to other sheets in the folder. When I \"Save As New\" the hyperlinks stay with the blank sheets and not the newly…","categoryID":321,"dateInserted":"2021-01-22T18:10:58+00:00","dateUpdated":null,"dateLastComment":"2021-01-26T13:55:25+00:00","insertUserID":128376,"insertUser":{"userID":128376,"name":"Amanda Jeske","url":"https:\/\/community.smartsheet.com\/profile\/Amanda%20Jeske","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mfHUXpthLnw!BZdVwdde87o!shvqkJ_Zbiu","dateLastActive":"2023-06-26T12:22:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":128376,"lastUser":{"userID":128376,"name":"Amanda Jeske","url":"https:\/\/community.smartsheet.com\/profile\/Amanda%20Jeske","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!mfHUXpthLnw!BZdVwdde87o!shvqkJ_Zbiu","dateLastActive":"2023-06-26T12:22:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":184,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/75177\/saving-a-folder-of-sheets-with-hyperlinks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75177\/saving-a-folder-of-sheets-with-hyperlinks","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-01-26T11:24:34+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":70710,"type":"question","name":"How to use Countif when the cell is hyperlink to a url","excerpt":"I need to do a count of cell value which is a hyperlink to a url (the cell display a number that refers to the url) e.g. 285555 which links to (http:\/\/blahblahbla.com\/285555). How do I use COUNTIF for this type of data in the cell? Thanks, Aye","categoryID":322,"dateInserted":"2020-08-19T16:36:24+00:00","dateUpdated":"2020-08-19T16:37:40+00:00","dateLastComment":"2020-08-19T16:48:27+00:00","insertUserID":105821,"insertUser":{"userID":105821,"name":"awollam105821","url":"https:\/\/community.smartsheet.com\/profile\/awollam105821","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!YTFbWHW1UPo!g3VZJwGvOoQ!C_drZ4Hrn43","dateLastActive":"2020-08-25T17:47:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":105821,"lastUserID":16866,"lastUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-10T17:47:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":1248,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/70710\/how-to-use-countif-when-the-cell-is-hyperlink-to-a-url","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70710\/how-to-use-countif-when-the-cell-is-hyperlink-to-a-url","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":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}">