讨论
0,{Store #}@row. However, that doesn't seem to be working.","categoryID":322,"dateInserted":"2023-03-10T18:05:39+00:00","dateUpdated":null,"dateLastComment":"2023-03-13T13:15:42+00:00","insertUserID":147369,"insertUser":{"userID":147369,"name":"PeggyLang","url":"https:\/\/community.smartsheet.com\/profile\/PeggyLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-16T11:58:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-16T17:50:53+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":76,"score":null,"hot":3357186681,"url":"https:\/\/community.smartsheet.com\/discussion\/102447\/formula-index-match-index-collect","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102447\/formula-index-match-index-collect","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/JWYHYMPACUIJ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-03-13T08:16:36+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":101490,"type":"question","name":"INDEX & Match","excerpt":"I have what I am calling a 'Lookup' Worksheet. I also have a Change Order Log, an Invoice Log and a Contract Log. I would like the 'Lookup' worksheet to return all Change Order(s) info, Invoice(s) info and Contract info. Column 'PC #' is hidden and each of the columns to the right of 'PC #' contain Index & match functions.…","categoryID":322,"dateInserted":"2023-02-21T20:14:53+00:00","dateUpdated":null,"dateLastComment":"2023-02-22T13:23:20+00:00","insertUserID":147369,"insertUser":{"userID":147369,"name":"PeggyLang","url":"https:\/\/community.smartsheet.com\/profile\/PeggyLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-16T11:58:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":139776,"lastUser":{"userID":139776,"name":"Ipshita","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ipshita","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/F9QTGWYO7ON4\/n1235F4AIWZTU.JPG","dateLastActive":"2023-06-14T06:49:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":66,"score":null,"hot":3354084493,"url":"https:\/\/community.smartsheet.com\/discussion\/101490\/index-match","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101490\/index-match","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/2A0DRZKNNSNE\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-22T13:23:20+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]},{"discussionID":101300,"type":"question","name":"Calculate new contract amount when change order is approved.","excerpt":"I need a formula that will calculate 'New Contract Total' (Original Contract + Change Order Amount) WHEN Status = Approved.","categoryID":322,"dateInserted":"2023-02-16T19:36:35+00:00","dateUpdated":null,"dateLastComment":"2023-02-17T01:56:18+00:00","insertUserID":147369,"insertUser":{"userID":147369,"name":"PeggyLang","url":"https:\/\/community.smartsheet.com\/profile\/PeggyLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-16T11:58:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":147369,"lastUser":{"userID":147369,"name":"PeggyLang","url":"https:\/\/community.smartsheet.com\/profile\/PeggyLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-16T11:58:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":70,"score":null,"hot":3353176373,"url":"https:\/\/community.smartsheet.com\/discussion\/101300\/calculate-new-contract-amount-when-change-order-is-approved","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101300\/calculate-new-contract-amount-when-change-order-is-approved","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/RXMQ8O4J28ZG\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-17T01:56:29+00:00","dateAnswered":"2023-02-16T21:01:04+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":false,"noCheckboxes":true}">
