探索。问。回答

=TODAY)","categoryID":322,"dateInserted":"2022-12-02T17:29:47+00:00","dateUpdated":null,"dateLastComment":"2022-12-02T21:20:24+00:00","insertUserID":130083,"insertUser":{"userID":130083,"name":"Kimberly Poletes","url":"https:\/\/community.smartsheet.com\/profile\/Kimberly%20Poletes","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3adCv9UkFDw!H1DD30kbgVY!a_y4TIERaNo","dateLastActive":"2022-12-02T17:47:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-12-05T19:12:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":13,"score":null,"hot":3340018811,"url":"https:\/\/community.smartsheet.com\/discussion\/98372\/countif-or-countifs","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98372\/countif-or-countifs","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-12-02T21:20:24+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":[],"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":66223,"type":"question","name":"Text to different Rows - Split by delimiter.","excerpt":"Hi, I have a cell@row value in the column Zone1 separated by a delimiter which needs to be split into different rows as a list of values similar to column Zone1new. Could i get help on this?","categoryID":321,"dateInserted":"2020-02-24T07:27:57+00:00","dateUpdated":"2020-02-24T07:29:01+00:00","dateLastComment":"2022-12-02T21:13:35+00:00","insertUserID":69881,"insertUser":{"userID":69881,"name":"prathap.krishnashetty69881","url":"https:\/\/community.smartsheet.com\/profile\/prathap.krishnashetty69881","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!gpjBn27AuyQ!n-FAfzbrfnw!2d9uMJ637uR","dateLastActive":"2022-08-08T09:38:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":69881,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-12-05T19:12:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":22,"countViews":3428,"score":null,"hot":3252558092,"url":"https:\/\/community.smartsheet.com\/discussion\/66223\/text-to-different-rows-split-by-delimiter","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66223\/text-to-different-rows-split-by-delimiter","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/038\/ODJSSLVRBP2U.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-02-24T17:32:38+00:00","dateAnswered":"2020-02-24T14:21:26+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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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}">