如何获得社区积分和徽章

No worries!<\/p>

Happy to help!<\/p>

Try something like this.<\/p>

=COUNTIF([Office Engagement]@row, CONTAINS(\"Calls\", @cell))<\/p>

Did that work?<\/p>

✅Remember! <\/strong>Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up\/Awesome or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-26 17:18:54","updateUser":{"userID":150538,"name":"Preston P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Preston%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2022-09-26T18:13:59+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":95905,"type":"question","name":"Vlookup from Created Date column","excerpt":"Hello, I'm having trouble when I use vlookup from a column typed as \"created date\", every time a date is created after 6pm, my vlookup returns the following day, as shown in the screenshoot. Is there a way to fix this?","categoryID":322,"dateInserted":"2022-09-26T15:29:00+00:00","dateUpdated":"2022-09-26T17:18:25+00:00","dateLastComment":"2022-09-26T17:55:23+00:00","insertUserID":152832,"insertUser":{"userID":152832,"name":"Clayton Ferreira","url":"https:\/\/community.smartsheet.com\/profile\/Clayton%20Ferreira","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7dsvu45DVHs!mTMo3r-xMIs!vfSAAaE11Wq","dateLastActive":"2022-09-26T17:48:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":150538,"lastUserID":116407,"lastUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2022-09-26T18:43:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":24,"score":null,"hot":3328422863,"url":"https:\/\/community.smartsheet.com\/discussion\/95905\/vlookup-from-created-date-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95905\/vlookup-from-created-date-column","format":"Rich","lastPost":{"discussionID":95905,"commentID":344799,"name":"Re: Vlookup from Created Date column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344799#Comment_344799","dateInserted":"2022-09-26T17:55:23+00:00","insertUserID":116407,"insertUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2022-09-26T18:43:30+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-09-26T17:48:54+00:00","dateAnswered":"2022-09-26T16:06:28+00:00","acceptedAnswers":[{"commentID":344768,"body":"