@Marilen.Navarro103391<\/a> <\/p>Please use the formula I provided. It was intentional for the character \"~\" to be included. <\/p>
=MID(Name@row, FIND(\"~\", SUBSTITUTE(Name@row, \"-\", \"~\", 5)) + 1, FIND(\"~\", SUBSTITUTE(Name@row, \"-\", \"~\", 6)) - 1 - FIND(\"~\", SUBSTITUTE(Name@row, \"-\", \"~\", 5)))<\/p>
Kelly<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":106483,"type":"question","name":"Cross Sheet formula from two different columns","excerpt":"Hi Friends, I am currently using sheet A that has its rows automatically filled up by bringing the value from another sheet B using the VLOOKUP function. For example, I manually fill up \"BIM ID\" column in sheet A and hence the \"SO\" column in sheet A is filled up automatically by cross-checking sheet B using the formula:…","categoryID":322,"dateInserted":"2023-06-15T08:43:02+00:00","dateUpdated":null,"dateLastComment":"2023-06-19T03:57:12+00:00","insertUserID":139197,"insertUser":{"userID":139197,"name":"Yousef J.","url":"https:\/\/community.smartsheet.com\/profile\/Yousef%20J.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T03:57:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":139197,"lastUser":{"userID":139197,"name":"Yousef J.","url":"https:\/\/community.smartsheet.com\/profile\/Yousef%20J.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T03:57:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":66,"score":null,"hot":3373969214,"url":"https:\/\/community.smartsheet.com\/discussion\/106483\/cross-sheet-formula-from-two-different-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106483\/cross-sheet-formula-from-two-different-columns","format":"Rich","lastPost":{"discussionID":106483,"commentID":381115,"name":"Re: Cross Sheet formula from two different columns","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381115#Comment_381115","dateInserted":"2023-06-19T03:57:12+00:00","insertUserID":139197,"insertUser":{"userID":139197,"name":"Yousef J.","url":"https:\/\/community.smartsheet.com\/profile\/Yousef%20J.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T03:57:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T03:57:35+00:00","dateAnswered":"2023-06-16T14:12:41+00:00","acceptedAnswers":[{"commentID":381013,"body":"
I haven't dived in deep but one thing I noticed is on the first reference you have two sets of {} this can give an error.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">