讨论
TODAY(), CONTAINS(\"2号室 Room 2\", [問題報告RV東照明 Reporting Issue RVE Lighting]:[問題報告RV東照明 Reporting Issue RVE Lighting])),…","categoryID":322,"dateInserted":"2022-09-29T01:37:08+00:00","dateUpdated":null,"dateLastComment":"2022-09-30T00:25:38+00:00","insertUserID":152523,"insertUser":{"userID":152523,"name":"CRUSJ","title":"","url":"https:\/\/community.smartsheet.com\/profile\/CRUSJ","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T03:24:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":2855,"lastUser":{"userID":2855,"name":"Mike Blumenstein","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Blumenstein","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/78\/c7\/n78c7f79f6b6cb28de9b6dc56931d7e5b.jpg","dateLastActive":"2023-06-15T20:57:05+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":82,"score":null,"hot":3328915366,"url":"https:\/\/community.smartsheet.com\/discussion\/96038\/combining-if-statements-is-not-working-with-comma","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96038\/combining-if-statements-is-not-working-with-comma","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-29T02:41:27+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":95575,"type":"question","name":"Create a formula to total the individual values of a dropdown list from one column?","excerpt":"So I have a dropdown column that has 12 options and it does allow multiple selections. Each of these items is worth 0.5 value. I am trying to create a formula for another column to report the total value selected in this column by the end user. So if the user selects 3 of these items from the dropdown, I need the formula…","categoryID":322,"dateInserted":"2022-09-20T17:19:25+00:00","dateUpdated":"2022-09-20T17:20:22+00:00","dateLastComment":"2022-09-20T20:06:31+00:00","insertUserID":152523,"insertUser":{"userID":152523,"name":"CRUSJ","title":"","url":"https:\/\/community.smartsheet.com\/profile\/CRUSJ","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T03:24:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":152523,"lastUserID":152523,"lastUser":{"userID":152523,"name":"CRUSJ","title":"","url":"https:\/\/community.smartsheet.com\/profile\/CRUSJ","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T03:24:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":203,"score":null,"hot":3327401156,"url":"https:\/\/community.smartsheet.com\/discussion\/95575\/create-a-formula-to-total-the-individual-values-of-a-dropdown-list-from-one-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95575\/create-a-formula-to-total-the-individual-values-of-a-dropdown-list-from-one-column","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/QW0SMJICJ1KO\/smartsheet-forum-screenshot.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet Forum screenshot.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-20T20:05:46+00:00","dateAnswered":"2022-09-20T20:03:19+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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":false,"noCheckboxes":true}">
