添加Ons和集成

I normally count another column that has a value and compare that against the status\/Test Outcome column. For example, if there was a PROJECT column and a STATUS column, I would write the formula like this:<\/p>

=COUNTIFS(PROJECT:PROJECT, <>\"//www.santa-greenland.com/community/categories/apps-and-integrations/\", STATUS:STATUS, \"//www.santa-greenland.com/community/categories/apps-and-integrations/\")<\/p>

It reads, If the Project column is not blank and the Status (or Test Outcome) column is blank, then could the blanks in the Status column.<\/p>

I hope that helps.<\/p>

Matt<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-20 19:49:17","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-01-21T02:23:14+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":[]},{"discussionID":99947,"type":"question","name":"Rounding Summary Numbers in Reports","excerpt":"We have reports that show us turnaround times for certain items. We are using the summarize feature to take an average for those turnaround times, but the decimals do not come out cleanly or consistently. Is there a way to round these averages so that it is a whole number?","categoryID":321,"dateInserted":"2023-01-20T15:07:14+00:00","dateUpdated":null,"dateLastComment":"2023-01-20T16:42:53+00:00","insertUserID":157151,"insertUser":{"userID":157151,"name":"AshleyDeichmueller","url":"https:\/\/community.smartsheet.com\/profile\/AshleyDeichmueller","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!yVdp8nPf8bs!Aj8oR9fpO_s!7MuMrhnDdUp","dateLastActive":"2023-01-20T16:43:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137019,"lastUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-01-20T20:48:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":42,"score":null,"hot":3348463207,"url":"https:\/\/community.smartsheet.com\/discussion\/99947\/rounding-summary-numbers-in-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99947\/rounding-summary-numbers-in-reports","format":"Rich","tagIDs":[265],"lastPost":{"discussionID":99947,"commentID":358004,"name":"Re: Rounding Summary Numbers in Reports","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/358004#Comment_358004","dateInserted":"2023-01-20T16:42:53+00:00","insertUserID":137019,"insertUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-01-20T20:48:58+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\/BQ70DOZOR69W\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-20T16:43:34+00:00","dateAnswered":"2023-01-20T16:42:53+00:00","acceptedAnswers":[{"commentID":358004,"body":"