如何获得社区积分和徽章

The Helper Join column formula is =Student@row + [Start Date]@row<\/p>

The Count formula is =COUNT(DISTINCT([Helper Join]:[Helper Join]))<\/p>

<\/p>

Hope that helps!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-23 14:46:33","updateUser":{"userID":144707,"name":"Kavs ","url":"https:\/\/community.smartsheet.com\/profile\/Kavs%20","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T15:57:42+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":95818,"type":"question","name":"Grab the numbers in a cell to another column then get their average. Substitute, AVG not working","excerpt":"I need to get the TC values only and then get their average (to be place on sheet summary). But it appears that when you try to use replace or substitute, it is converting them to text. Value and INT can be used, but I tried both and its not working for my sample.","categoryID":321,"dateInserted":"2022-09-22T20:22:55+00:00","dateUpdated":null,"dateLastComment":"2022-09-23T13:26:30+00:00","insertUserID":139461,"insertUser":{"userID":139461,"name":"heyjay","url":"https:\/\/community.smartsheet.com\/profile\/heyjay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T13:25:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":139461,"lastUser":{"userID":139461,"name":"heyjay","url":"https:\/\/community.smartsheet.com\/profile\/heyjay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T13:25:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":19,"score":null,"hot":3327818365,"url":"https:\/\/community.smartsheet.com\/discussion\/95818\/grab-the-numbers-in-a-cell-to-another-column-then-get-their-average-substitute-avg-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95818\/grab-the-numbers-in-a-cell-to-another-column-then-get-their-average-substitute-avg-not-working","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":95818,"commentID":344550,"name":"Re: Grab the numbers in a cell to another column then get their average. Substitute, AVG not working","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344550#Comment_344550","dateInserted":"2022-09-23T13:26:30+00:00","insertUserID":139461,"insertUser":{"userID":139461,"name":"heyjay","url":"https:\/\/community.smartsheet.com\/profile\/heyjay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T13:25:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/87KO01KRYU3J\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-23T13:26:37+00:00","dateAnswered":"2022-09-23T13:26:30+00:00","acceptedAnswers":[{"commentID":344550,"body":"

Solved. Used IF + CONTAINS instead.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-23 13:26:37","updateUser":{"userID":139461,"name":"heyjay","url":"https:\/\/community.smartsheet.com\/profile\/heyjay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T13:25:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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"}]}],"title":"Trending Community Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">