包含，匹配，索引帮助
我试图在交叉表公式中使用CONTAINS、MATCH和INDEX，将特定位置的系统组件检查信息从发票拉到我的资产注册表中。
有时，发票上会有多个系统组件。
我想确保公式将提取每个系统组件的信息。在附上的第11行截图中，我将得到1月1日和2月2日灭火器的结果为“2/28/19”。
我创建了一个连接位置和系统组件的列，但我不确定这是否适用于具有多个组件的发票。
任何想法吗?
评论
-
保罗新来的 ✭✭✭✭✭✭ -
确定。下面是我的资产注册表截图。我想从我的FLS发票登记簿中将[发票日期]拉到[上次检查]列中。
正如您所看到的，每个站点都有几个系统，并且检查可以组合在一起。
如果我手动操作，我将在发票和资产注册之间来回切换，在发票进入时更新[最后一次检查]列。
-
保罗新来的 ✭✭✭✭✭✭
帮助文章参考资料欧宝体育app官方888
类别
You would need to use a third party app such as Zapier, the premium add-on Bridge, or the API to get it to work exactly like that.<\/p>
<\/p>
If you are ok with the link being in another column, you can use this formula:<\/p>
=\"www.acmetickets.com\/ticket\/\" + [Ticket Number Column Name]@row <\/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":[{"tagID":331,"urlcode":"hyperlink","name":"hyperlink"}]},{"discussionID":106493,"type":"question","name":"Need a formula to take a filename and alter the text","excerpt":"I need a formula that will take a filename and then remove the underscores and replace with periods and make the text lowercase. I am having trouble know what function to use to remove the underscores. Filename example: JK_T1_L1_NewFile The filename always follows this rules - 2 letters_2 letters__2 letters _filename I…","categoryID":322,"dateInserted":"2023-06-15T14:06:14+00:00","dateUpdated":"2023-06-15T14:15:38+00:00","dateLastComment":"2023-06-15T15:31:51+00:00","insertUserID":162413,"insertUser":{"userID":162413,"name":"kpierson109","url":"https:\/\/community.smartsheet.com\/profile\/kpierson109","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T19:23:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162413,"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":"2023-06-15T17:43:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":27,"score":null,"hot":3373682885,"url":"https:\/\/community.smartsheet.com\/discussion\/106493\/need-a-formula-to-take-a-filename-and-alter-the-text","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106493\/need-a-formula-to-take-a-filename-and-alter-the-text","format":"Rich","lastPost":{"discussionID":106493,"commentID":380824,"name":"Re: Need a formula to take a filename and alter the text","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380824#Comment_380824","dateInserted":"2023-06-15T15:31:51+00:00","insertUserID":45516,"insertUser":{"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":"2023-06-15T17:43:16+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-15T15:34:11+00:00","dateAnswered":"2023-06-15T14:16:00+00:00","acceptedAnswers":[{"commentID":380785,"body":"
Try this:<\/p>
=LOWER(SUBSTITUTE([Column Name]@row, \"_\", \"\"))<\/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":[]}">
