公式与函数

Try this:<\/p>

=IF(Date@row <> \"//www.santa-greenland.com/community/categories/formulas-and-functions/\", \"Green\", \"Red\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-09 19:42:54","updateUser":{"userID":152534,"name":"Jessewise","url":"https:\/\/community.smartsheet.com\/profile\/Jessewise","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-09T19:45:24+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":98615,"type":"question","name":"Cannot get total number of checked boxes to work","excerpt":"I have tried every formula i could find here, but i cannot get it to count how many checkboxes are checked in a column. The checkboxes are in Column \"Check\" and go from row 1-99\" i am putting the formula in row 100 (so directly below the checkboxes). Here is the formula i have narrowed it down to, but still doesnt work:…","categoryID":322,"dateInserted":"2022-12-09T15:08:46+00:00","dateUpdated":null,"dateLastComment":"2022-12-09T18:38:27+00:00","insertUserID":155843,"insertUser":{"userID":155843,"name":"Jhoaas","url":"https:\/\/community.smartsheet.com\/profile\/Jhoaas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-09T18:11:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":148574,"lastUser":{"userID":148574,"name":"Ryan Sides","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Sides","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp4daj1zcf91nI29fOQD59cy3z-VGRPfGKMTIxsCOA=s96-c","dateLastActive":"2022-12-09T21:45:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":37,"score":null,"hot":3341212033,"url":"https:\/\/community.smartsheet.com\/discussion\/98615\/cannot-get-total-number-of-checked-boxes-to-work","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98615\/cannot-get-total-number-of-checked-boxes-to-work","format":"Rich","lastPost":{"discussionID":98615,"commentID":353869,"name":"Re: Cannot get total number of checked boxes to work","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/353869#Comment_353869","dateInserted":"2022-12-09T18:38:27+00:00","insertUserID":148574,"insertUser":{"userID":148574,"name":"Ryan Sides","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Sides","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp4daj1zcf91nI29fOQD59cy3z-VGRPfGKMTIxsCOA=s96-c","dateLastActive":"2022-12-09T21:45:14+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-12-09T18:13:18+00:00","dateAnswered":"2022-12-09T16:28:49+00:00","acceptedAnswers":[{"commentID":353821,"body":"