Formulas and Functions

0) This works fine when the column VP contains actual values with text. However, if I put in a column formula to calculate their name from a…","categoryID":322,"dateInserted":"2020-10-27T19:20:03+00:00","dateUpdated":null,"dateLastComment":"2020-10-28T10:18:27+00:00","insertUserID":125818,"insertUser":{"userID":125818,"name":"Steve Rieger","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Steve%20Rieger","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-11-23T19:42:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-27T07:46:30+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":115,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/72614\/sheet-summary-formula-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72614\/sheet-summary-formula-error","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-28T10:18:30+00:00","dateAnswered":"2020-10-27T19:59:18+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":335,"urlcode":"sheet-summary","name":"Sheet Summary"}],"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":72612,"type":"question","name":"Find function not working. Can you help?","excerpt":"I'm trying to count a particular name in a column but keep getting the #Unparseable error. =COUNTIFS({LR Date Created}, IFERROR(YEAR(@cell), 0) = 2020, {LR Date Created}, IFERROR(MONTH(@cell), 0) = Month@row, {Assigned To}, FIND(“Kamil”, @cell)>0) Can you help???","categoryID":322,"dateInserted":"2020-10-27T18:26:33+00:00","dateUpdated":null,"dateLastComment":"2020-10-28T10:17:03+00:00","insertUserID":124620,"insertUser":{"userID":124620,"name":"Guangda Shi","url":"https:\/\/community.smartsheet.com\/profile\/Guangda%20Shi","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BwtZARGm4bw!GSNWnpGTs7w!KWHepxnWEKh","dateLastActive":"2021-04-09T18:53:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-27T07:46:30+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":73,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/72612\/find-function-not-working-can-you-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72612\/find-function-not-working-can-you-help","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":[],"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":72624,"type":"question","name":"Sheet Summary formula not working","excerpt":"Any ideas as to why this formula isn't working? =COUNTIF([Return- boundaries between works areas]:[Return- boundaries between works areas], \"Very Important\") I coped the column name from the actual column as to not misspell anything etc. Then I tried typing it out thinking maybe the copy and paste went screwy. Nothing…","categoryID":322,"dateInserted":"2020-10-28T00:22:34+00:00","dateUpdated":null,"dateLastComment":"2020-10-28T01:33:05+00:00","insertUserID":115499,"insertUser":{"userID":115499,"name":"Christina Riot","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20Riot","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k5taP4WWQno!HGlZX_GLgjw!-jaBSPTIk7Q","dateLastActive":"2023-04-19T21:21:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":112221,"lastUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2023-08-26T20:20:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":107,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72624\/sheet-summary-formula-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72624\/sheet-summary-formula-not-working","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":[],"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":72616,"type":"question","name":"Returning a value based on multiple criteria","excerpt":"I am trying to autofill a summary table using formulas. I am able to autofill the monthly counts using date criteria, but I can't get the total numbers to autofill. I tried using the below formulas to pull from the two places where I have the counts for total members and total new members of each member type, but I keep…","categoryID":322,"dateInserted":"2020-10-27T20:35:10+00:00","dateUpdated":null,"dateLastComment":"2020-10-27T22:40:32+00:00","insertUserID":119498,"insertUser":{"userID":119498,"name":"Annie Lindenberg","url":"https:\/\/community.smartsheet.com\/profile\/Annie%20Lindenberg","photoUrl":"https:\/\/lh6.googleusercontent.com\/-V5SAXwZWCOY\/AAAAAAAAAAI\/AAAAAAAAAAA\/AMZuucmEWsVS94ARd1knU2ZbtPJ5xHCbYw\/s96-c\/photo.jpg","dateLastActive":"2020-11-17T21:20:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":115578,"lastUser":{"userID":115578,"name":"David Joyeuse","url":"https:\/\/community.smartsheet.com\/profile\/David%20Joyeuse","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2021-08-19T14:05:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":313,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72616\/returning-a-value-based-on-multiple-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72616\/returning-a-value-based-on-multiple-criteria","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/1SO0YC6ZE69B\/screen-shot-2020-10-27-at-3-29-41-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2020-10-27 at 3.29.41 PM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-28T14:45:13+00:00","dateAnswered":"2020-10-27T22:40:32+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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Help Article Resources