@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":65,"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&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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 Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
热门文章
索引匹配，如何识别多个值? 你好，我有一个问题与我的索引匹配公式。我要找到那个设施的序列号。当内部只有一个值时，这可以完美地工作。但是，为了减少相应表单上的列和选项的数量，我将其更改为具有多个值的一列。公式是…
分割文本 有人能帮帮我吗?我需要一个关于如何分割文本的公式。例LOW - VS-87 - Service-FS电池更换铅-MEGA MALL-1259410我需要一个只写MEGA MALL的专栏。
交叉表公式从两个不同的列 嗨，朋友们，我目前使用的表A有它的行自动填写通过使用VLOOKUP函数从另一个表B带来的值。例如，我手动填写了A表中的“BIM ID”列，因此A表中的“SO”列通过交叉检查B表，使用公式自动填写:…
J.克雷格·威廉姆斯 ✭✭✭✭✭✭
Jaye Casciano ✭✭✭✭✭✭
