Formulas and Functions

1,1,0) . The problem is that this doesn't work for…","categoryID":322,"dateInserted":"2021-01-07T21:46:36+00:00","dateUpdated":null,"dateLastComment":"2021-01-13T00:20:17+00:00","insertUserID":130428,"insertUser":{"userID":130428,"name":"Eric Busse","url":"https:\/\/community.smartsheet.com\/profile\/Eric%20Busse","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wSvAsL7h0Pw!pOlBKWLyqbo!mu8v4UriiSw","dateLastActive":"2021-01-13T00:55:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":126171,"lastUser":{"userID":126171,"name":"Mark Cronk","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Cronk","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9UVGVH5TN00I\/nO060PSRF4UVU.jpg","dateLastActive":"2023-05-10T19:07:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":173,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/74630\/is-it-possible-to-flag-duplicates-when-the-data-starts-with-a-0-zero","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/74630\/is-it-possible-to-flag-duplicates-when-the-data-starts-with-a-0-zero","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-01-12T22:16:39+00:00","dateAnswered":"2021-01-12T00:53:41+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}]},{"discussionID":74764,"type":"question","name":"Formula Help","excerpt":"Not the greatest at creating formulas so I am looking for some assistance on this one. =IF(CONTAINS(\"0\", [Product Categories selected]@row:[Keyword field filled]@row), \"Complete\", \"Incomplete\") Here is what I am looking to do: If the four columns are all \"O\" then mark the status of Incomplete but if all four columns are…","categoryID":322,"dateInserted":"2021-01-12T22:16:54+00:00","dateUpdated":null,"dateLastComment":"2021-01-12T22:43:51+00:00","insertUserID":119359,"insertUser":{"userID":119359,"name":"Manuel Lemus","url":"https:\/\/community.smartsheet.com\/profile\/Manuel%20Lemus","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!4RDP-MieUZQ!pqtMaRTZvro!NQoUb2fCEd8","dateLastActive":"2023-06-20T22:53:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":119359,"lastUser":{"userID":119359,"name":"Manuel Lemus","url":"https:\/\/community.smartsheet.com\/profile\/Manuel%20Lemus","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!4RDP-MieUZQ!pqtMaRTZvro!NQoUb2fCEd8","dateLastActive":"2023-06-20T22:53:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":53,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/74764\/formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/74764\/formula-help","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/EUQBN3RHVNB7\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-01-12T22:43:07+00:00","dateAnswered":"2021-01-12T22:39:40+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":74760,"type":"question","name":"Sumif\/Sumifs question","excerpt":"I have a sheet that lists the number of awards that have been issued since the inception of the program. I want to create a report that breaks it out by year, award level (there are 3 different levels), and sum the total of that level. I have it by year, but adding the level I have not been able to figure out. Can someone…","categoryID":322,"dateInserted":"2021-01-12T21:37:40+00:00","dateUpdated":null,"dateLastComment":"2021-01-12T21:47:26+00:00","insertUserID":127769,"insertUser":{"userID":127769,"name":"Dale Callaway","url":"https:\/\/community.smartsheet.com\/profile\/Dale%20Callaway","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7A9V-1NeRnw!7yDUu-9jQ-Y!E3f92JewteF","dateLastActive":"2022-04-06T21:46:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":21226,"lastUser":{"userID":21226,"name":"Jason Tarpinian","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20Tarpinian","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-14T13:11:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":62,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/74760\/sumif-sumifs-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/74760\/sumif-sumifs-question","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Help Article Resources