索引匹配，如何识别多个值?
你好,
我的索引匹配公式有一个问题。我要找到那个设施的序列号。当内部只有一个值时，这可以完美地工作。但是，为了减少相应表单上的列和选项的数量，我将其更改为具有多个值的一列。公式很难看出该列中存在序列号，因为单元格中有两个。我怎么解决这个问题?
下面的工作公式(当它返回到库存时，它为正，表示它回到了名为“pes”的家庭仓库)
=如果((电子邮件保护)> 0， "PES"， INDEX(Facility:Facility, MATCH(6633112443，[显微镜:1]:[显微镜:1]，0))
但是，当我更改列以允许在一个单元格中包含多个值时，它不再识别序列号。
任何帮助都是感激的!
谢谢,
最佳答案
答案
-
我不确定这是如何工作的，但它似乎是完美的!!我终于可以完成表格了。这个问题从周三开始就一直困扰着我。我是智能表的新手，不太理解一次使用多个函数时应该如何填充顺序或参数。
太棒了:)这将是美好的一周
谢谢
帮助文章参考资料欧宝体育app官方888
类别
In Smartsheet you'd need to add @row to the GLAcct portion of your the formula. <\/p>
For example, the first section would be:<\/p>
=IF(OR(GLAcct@row = \"710111\", GLAcct@row = \"710121\"), \"Key Salary\")<\/p>
Once you've entered it for one row, you can then right click the cell and \"Convert to Column Formula\" to have it applied to all rows in the column. <\/p>
Other than that, I think everything should be OK once you add the @row in.<\/p>
Hope that helps; any questions etc. then just post! 😊<\/span><\/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":106682,"type":"question","name":"Make sum of one column in function of value of another","excerpt":"Hello everybody, I did not find my answer in the different discussions, then I hope you will be able to help me. I have a smart sheet with 2 columns: Part number Quantity I would like to count the total of parts with a certain number. Finally, it is an addition of the quantity when the P\/N is equal to a certain value. I…","categoryID":322,"dateInserted":"2023-06-21T06:31:14+00:00","dateUpdated":"2023-06-21T07:41:41+00:00","dateLastComment":"2023-06-21T11:14:19+00:00","insertUserID":159154,"insertUser":{"userID":159154,"name":"Guillaume B.","url":"https:\/\/community.smartsheet.com\/profile\/Guillaume%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/S5NT3AR3967R\/nA4FRK2S3XJG9.jpg","dateLastActive":"2023-06-21T13:09:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":159154,"lastUserID":159154,"lastUser":{"userID":159154,"name":"Guillaume B.","url":"https:\/\/community.smartsheet.com\/profile\/Guillaume%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/S5NT3AR3967R\/nA4FRK2S3XJG9.jpg","dateLastActive":"2023-06-21T13:09:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":33,"score":null,"hot":3374676333,"url":"https:\/\/community.smartsheet.com\/discussion\/106682\/make-sum-of-one-column-in-function-of-value-of-another","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106682\/make-sum-of-one-column-in-function-of-value-of-another","format":"Rich","lastPost":{"discussionID":106682,"commentID":381436,"name":"Re: Make sum of one column in function of value of another","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381436#Comment_381436","dateInserted":"2023-06-21T11:14:19+00:00","insertUserID":159154,"insertUser":{"userID":159154,"name":"Guillaume B.","url":"https:\/\/community.smartsheet.com\/profile\/Guillaume%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/S5NT3AR3967R\/nA4FRK2S3XJG9.jpg","dateLastActive":"2023-06-21T13:09:56+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-21T11:14:29+00:00","dateAnswered":"2023-06-21T11:14:19+00:00","acceptedAnswers":[{"commentID":381436,"body":" I finally found the correct formula:<\/p> Like that it is working partially, because as I have sub assemblies, I will need to take the quantity of the PARENT() and multiply it to have the correct value.<\/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":106658,"type":"question","name":"How do I fill a date series from left to right?","excerpt":"I found an answer with an incredibly complicated formula for text fields, but I wanted to ask again just to be certain - is there no way to drag-fill a date series from left to right in Smartsheets? I don't want the entire column to be dates, just the one row, so you can see that Week 25 is the week of 6\/19\/23, for…","categoryID":322,"dateInserted":"2023-06-20T18:50:57+00:00","dateUpdated":null,"dateLastComment":"2023-06-21T18:24:14+00:00","insertUserID":162215,"insertUser":{"userID":162215,"name":"Jessica Weiss","title":"Production Manager","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Weiss","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uvtc5xY6nz0!!XANJ4bk168O","dateLastActive":"2023-06-21T18:24:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162215,"lastUser":{"userID":162215,"name":"Jessica Weiss","title":"Production Manager","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Weiss","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uvtc5xY6nz0!!XANJ4bk168O","dateLastActive":"2023-06-21T18:24:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":13,"countViews":48,"score":null,"hot":3374666711,"url":"https:\/\/community.smartsheet.com\/discussion\/106658\/how-do-i-fill-a-date-series-from-left-to-right","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106658\/how-do-i-fill-a-date-series-from-left-to-right","format":"Rich","lastPost":{"discussionID":106658,"commentID":381580,"name":"Re: How do I fill a date series from left to right?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381580#Comment_381580","dateInserted":"2023-06-21T18:24:14+00:00","insertUserID":162215,"insertUser":{"userID":162215,"name":"Jessica Weiss","title":"Production Manager","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Weiss","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uvtc5xY6nz0!!XANJ4bk168O","dateLastActive":"2023-06-21T18:24:29+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-21T18:00:43+00:00","dateAnswered":"2023-06-21T17:37:22+00:00","acceptedAnswers":[{"commentID":381561,"body":" I missed a small piece in my formula. Is there a face palm emoji? Ugh. There should also be a $ before the first cell reference to lock that one in as well to keep it from updating during dragfill.<\/p> =($[W1]@row + (7 * COUNT($[W1]@row:[W1]@row))) + \"//m.santa-greenland.com/community/discussion/106584/\"<\/p>"},{"commentID":381571,"body":" 💥 BOOM! 💥 That did it, my friend! Thank you so much, @Paul Newcome<\/a>!<\/p>
=SUMIF([Part number]$185:[Part number]$369, CONTAINS([Part number]167, @cell), Quantity$185:Quantity$369)<\/code><\/strong><\/p>
<\/p>
![\"Screenshot](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/IMAPB5F7QO9K\/screenshot-2023-06-21-at-1-49-48-pm.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
