Formulas and Functions

20, [Transaction Total]1:[Transaction Total]3)Revenue Gained. SUM…","categoryID":322,"dateInserted":"2019-10-07T18:03:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-08T08:37:53+00:00","insertUserID":84976,"insertUser":{"userID":84976,"name":"yheng","url":"https:\/\/community.smartsheet.com\/profile\/yheng","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!neDCf60rEeQ!5aHDOV0ydHw!WUYkctVwP2z","dateLastActive":"2022-11-01T19:14:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":597,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/59581\/sumif-formula-incorrect-result","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/59581\/sumif-formula-incorrect-result","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-10\/98\/d4\/98d49a7b3c898c16a14d2ed3a0cf377e.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2019-10-07_14-55-14.jpg"},"attributes":{},"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"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":59636,"type":"discussion","name":"Formula to Outdent a row, when a certain status is reached","excerpt":"Hi all, I've been using Smartsheet for a while now, love it, but I'm a bit rubbish with formulas. I'm trying to have tasks 'de-parent' from its parent task (Outdent to '0') when a certain status is set. I got to this formula (to no avail, but to help illustrate what I'm on about): =IF(Status143:Status159)=\"COMPLETE…","categoryID":322,"dateInserted":"2019-10-08T07:25:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-08T07:29:16+00:00","insertUserID":76571,"insertUser":{"userID":76571,"name":"Mik","url":"https:\/\/community.smartsheet.com\/profile\/Mik","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-08T07:13:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":61,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/59636\/formula-to-outdent-a-row-when-a-certain-status-is-reached","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/59636\/formula-to-outdent-a-row-when-a-certain-status-is-reached","format":"Html","groupID":null,"statusID":0,"attributes":{},"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":59546,"type":"discussion","name":"Change RYBG Color if the year is Greater than the current year","excerpt":"Hello, I currently have this: =IF([Wants refresh?]2 = \"Yes\", \"Green\", IF([Wants refresh?]2 = \"No\", \"Gray\")) Which is working fine, but now I want to add that if the column Refresh Year has the year greater than the current year (2019) for it to turn red. I am not sure how to write that. Any ideas? Thank you!","categoryID":322,"dateInserted":"2019-10-07T14:46:04+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-07T15:47:33+00:00","insertUserID":40981,"insertUser":{"userID":40981,"name":"Lisi","url":"https:\/\/community.smartsheet.com\/profile\/Lisi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-07T11:34:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":40981,"lastUser":{"userID":40981,"name":"Lisi","url":"https:\/\/community.smartsheet.com\/profile\/Lisi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-07T11:34:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":71,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/59546\/change-rybg-color-if-the-year-is-greater-than-the-current-year","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/59546\/change-rybg-color-if-the-year-is-greater-than-the-current-year","format":"Html","groupID":null,"statusID":0,"attributes":{},"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":59441,"type":"discussion","name":"Formula help recognising multiple words","excerpt":"Hi, I have a formula that looks for a specific word or variance of the word, is it possible to look for more than one word? The formula i have is =COUNTIFS(Response1, FIND(\"shower\", LOWER(@cell)) > 0) This works for the word showers or shower which is perfect, however am i am able to count if the cell contains either…","categoryID":322,"dateInserted":"2019-10-04T18:58:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-07T14:33:30+00:00","insertUserID":56751,"insertUser":{"userID":56751,"name":"dave.mcpherson56751","url":"https:\/\/community.smartsheet.com\/profile\/dave.mcpherson56751","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-07-04T08:00:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":384,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/59441\/formula-help-recognising-multiple-words","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/59441\/formula-help-recognising-multiple-words","format":"Html","groupID":null,"statusID":0,"attributes":{},"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":59506,"type":"discussion","name":"Show Last Month of a Quarter","excerpt":"Hello, I have a column that has the quarter, like Q1, Q2, Q3, and Q4. Now I'm trying to show the last month of that quarter on a new column. I tried to use IF([Refresh Eligible Quarter]@row) = Q1, \"March\") but it doesn't work. Any idea? Thanks! ","categoryID":322,"dateInserted":"2019-10-07T11:38:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-07T14:15:37+00:00","insertUserID":40981,"insertUser":{"userID":40981,"name":"Lisi","url":"https:\/\/community.smartsheet.com\/profile\/Lisi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-07T11:34:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":74,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/59506\/show-last-month-of-a-quarter","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/59506\/show-last-month-of-a-quarter","format":"Html","groupID":null,"statusID":0,"attributes":{},"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":46476,"type":"discussion","name":"Simple Sum formula not working","excerpt":"I'm running into an issue where it appears the formulas that I have returning a number are not available for simple math in sum formulas. Any suggestions? For example, I have a column that produces the month a project will close based upon the estimated completion date currently linking in from the individual task lists. I…","categoryID":322,"dateInserted":"2019-04-23T09:55:01+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-07T13:27:00+00:00","insertUserID":69471,"insertUser":{"userID":69471,"name":"JVaihinger","url":"https:\/\/community.smartsheet.com\/profile\/JVaihinger","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-11\/4a\/38\/n4a38e90b61aef66bf264a924a859180e.jpg","dateLastActive":"2019-11-15T14:35:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":435,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/46476\/simple-sum-formula-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/46476\/simple-sum-formula-not-working","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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":57926,"type":"discussion","name":"formula help - sum if blank","excerpt":"I'm trying to run a formula to sum the numbers in a netdays row if another column is blank and am running into issues. Here is the formula that I have: =SUMIFS([Requested - Complete]81:[Requested - Complete]452, Q81:Q452, \"1\", [Survey Required]81:[Survey Required]452, \"//www.santa-greenland.com/community/categories/formulas-and-functions/\") Any help on what I am missing would be appreciated. ","categoryID":322,"dateInserted":"2019-09-17T15:03:21+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-07T13:26:06+00:00","insertUserID":69471,"insertUser":{"userID":69471,"name":"JVaihinger","url":"https:\/\/community.smartsheet.com\/profile\/JVaihinger","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-11\/4a\/38\/n4a38e90b61aef66bf264a924a859180e.jpg","dateLastActive":"2019-11-15T14:35:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":682,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/57926\/formula-help-sum-if-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/57926\/formula-help-sum-if-blank","format":"Html","groupID":null,"statusID":0,"attributes":{},"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":59486,"type":"discussion","name":"IF Statement to set a symbol to a value - #Incorrect Argument set","excerpt":"Good Day, I am trying to set a Symbol value using this IF statement but I get a \"#Incorrect argument Set =IF([Prev Year Difference]3, =0, \"Unchanged\", IF([Prev Year Difference]3, <0, \"Up\", \"Down\")) The column\/cell that I am using the formula in is defined as a \"Symbol\" using the \"3 Direction\" Up, Down & Unchanged. See…","categoryID":322,"dateInserted":"2019-10-07T10:44:09+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-07T12:11:30+00:00","insertUserID":51526,"insertUser":{"userID":51526,"name":"bday2329","title":"","url":"https:\/\/community.smartsheet.com\/profile\/bday2329","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-03-03T21:17:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":164,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/59486\/if-statement-to-set-a-symbol-to-a-value-incorrect-argument-set","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/59486\/if-statement-to-set-a-symbol-to-a-value-incorrect-argument-set","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-10\/9e\/2e\/9e2e12e82313ec95adf6f008907cbb16.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"If statement for Symbols.JPG"},"attributes":{},"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"},{"tagID":281,"urlcode":"support","name":"Support"}],"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":59511,"type":"discussion","name":"COUNTIF and Multi-Select","excerpt":"Hello all, Here is a sheet with examples of how to use a COUNTIF formula the release of Multi Select. Hope it helps! Best, Kara","categoryID":322,"dateInserted":"2019-10-07T11:54:25+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-07T12:05:07+00:00","insertUserID":279,"insertUser":{"userID":279,"name":"Kara Lumley","url":"https:\/\/community.smartsheet.com\/profile\/Kara%20Lumley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/95\/4e\/n954e10e9b436e9acd6f195bdf2312f07.jpg","dateLastActive":"2020-11-10T15:44:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":1087,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/59511\/countif-and-multi-select","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/59511\/countif-and-multi-select","format":"Html","groupID":null,"statusID":0,"attributes":{},"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