公式和函数

=IF([Corner Y\/N]@row = 1, SUM([B-1 QTY-Andy]@row:[B-3 QTY-Andy]@row), \"//www.santa-greenland.com/community/categories/formulas-and-functions/\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-23 13:48:45","updateUser":{"userID":55371,"name":"ryan.diamond55371","url":"https:\/\/community.smartsheet.com\/profile\/ryan.diamond55371","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xb9BMVLzN_o!p8NAqZLg3Lo!bBH3-mnPbmI","dateLastActive":"2022-11-23T13:48:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":98051,"type":"question","name":"MAX, COLLECT, MATCH Formula","excerpt":"I have a formula that is giving an \"incorrect argument\" error. =MAX(COLLECT({_Training Database Range 1}, MATCH([Primary Column]@row, {_Training Database Range 2}, 0), {_Training Database Range 3}, \"ROVER - SITE CALIBRATION\"), 0) I am trying to match a name for from a column (sheet 1) to a column in another sheet (sheet 2)…","categoryID":322,"dateInserted":"2022-11-22T19:25:17+00:00","dateUpdated":"2022-11-22T20:12:21+00:00","dateLastComment":"2022-11-22T23:55:37+00:00","insertUserID":155248,"insertUser":{"userID":155248,"name":"tani_1887","url":"https:\/\/community.smartsheet.com\/profile\/tani_1887","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5aHUuZ9id_4!-5PWd7seIzw!j5Ehst-9pQU","dateLastActive":"2022-11-22T23:49:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":155248,"lastUserID":155248,"lastUser":{"userID":155248,"name":"tani_1887","url":"https:\/\/community.smartsheet.com\/profile\/tani_1887","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5aHUuZ9id_4!-5PWd7seIzw!j5Ehst-9pQU","dateLastActive":"2022-11-22T23:49:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":23,"score":null,"hot":3338307654,"url":"https:\/\/community.smartsheet.com\/discussion\/98051\/max-collect-match-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98051\/max-collect-match-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":98051,"commentID":352066,"name":"Re: MAX, COLLECT, MATCH Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/352066#Comment_352066","dateInserted":"2022-11-22T23:55:37+00:00","insertUserID":155248,"insertUser":{"userID":155248,"name":"tani_1887","url":"https:\/\/community.smartsheet.com\/profile\/tani_1887","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5aHUuZ9id_4!-5PWd7seIzw!j5Ehst-9pQU","dateLastActive":"2022-11-22T23:49: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":"2022-11-23T13:50:35+00:00","dateAnswered":"2022-11-22T20:34:17+00:00","acceptedAnswers":[{"commentID":352058,"body":"

@tani_1887<\/a> <\/p>

Not clear on what you need. But try the below:<\/p>

=MAX(COLLECT({_Training Database Range 1}, {_Training Database Range 2}, @cell = [Primary Column]@row, {_Training Database Range 3}, @cell = \"ROVER - SITE CALIBRATION\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-23 13:50:35","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-11-23T13:55:55+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":98028,"type":"question","name":"Cross Reference from Form's Response sheet","excerpt":"Hi! I am currently working with 2 sheets - 1st sheet is the response from form where I'll be getting my data while 2nd sheet is where I want the details to be auto populated. However, when new response is submitted to the 1st sheet (thru the form), it shows #NOMATCH to the 2nd sheet. It seems that I have to update range of…","categoryID":322,"dateInserted":"2022-11-22T02:29:35+00:00","dateUpdated":null,"dateLastComment":"2022-11-23T11:56:13+00:00","insertUserID":150376,"insertUser":{"userID":150376,"name":"araregilme","url":"https:\/\/community.smartsheet.com\/profile\/araregilme","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-23T11:55:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":150376,"lastUser":{"userID":150376,"name":"araregilme","url":"https:\/\/community.smartsheet.com\/profile\/araregilme","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-23T11:55:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":42,"score":null,"hot":3338289948,"url":"https:\/\/community.smartsheet.com\/discussion\/98028\/cross-reference-from-forms-response-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98028\/cross-reference-from-forms-response-sheet","format":"Rich","lastPost":{"discussionID":98028,"commentID":352091,"name":"Re: Cross Reference from Form's Response sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/352091#Comment_352091","dateInserted":"2022-11-23T11:56:13+00:00","insertUserID":150376,"insertUser":{"userID":150376,"name":"araregilme","url":"https:\/\/community.smartsheet.com\/profile\/araregilme","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-23T11:55:45+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":"2022-11-23T11:55:59+00:00","dateAnswered":"2022-11-22T14:45:07+00:00","acceptedAnswers":[{"commentID":352010,"body":"

When creating the cross sheet references, select the column header(s) to have it select the entire column which will then grab all new rows as they are inserted.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-23 11:55:59","updateUser":{"userID":150376,"name":"araregilme","url":"https:\/\/community.smartsheet.com\/profile\/araregilme","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-23T11:55:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">