Formulas

=01\/01\/2022, <=03\/31\/2022\")","categoryID":322,"dateInserted":"2023-06-01T17:21:12+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T17:42:15+00:00","insertUserID":127483,"insertUser":{"userID":127483,"name":"Terry Naegelen","url":"https:\/\/community.smartsheet.com\/profile\/Terry%20Naegelen","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7YFXO-WzUvo!z0nWs5mjwTw!2zkZLn0fBJQ","dateLastActive":"2023-06-07T19:23:35+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-06-08T07:33:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":52,"score":null,"hot":3371716407,"url":"https:\/\/community.smartsheet.com\/discussion\/105909\/sumifs-the-two-columns-meet-the-criteria-for-each-column-usa","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105909\/sumifs-the-two-columns-meet-the-criteria-for-each-column-usa","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-07T10:58:48+00:00","dateAnswered":"2023-06-05T12:43:56+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":106046,"type":"question","name":"Need help writing a Nested IF, IF OR and IF AND Statements","excerpt":"I am trying to write the formula correctly, I have a couple different versions and neither are working. I can get the first 2 parts to work in this version, but the last part fails giving me INCORRECT ARGUMENT =IF(OR([Line of Business]@row = \"Valuation\", [Line of Business]@row = \"Property Management\"), \"Final\",…","categoryID":322,"dateInserted":"2023-06-06T00:26:37+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T15:13:27+00:00","insertUserID":91806,"insertUser":{"userID":91806,"name":"michelle.farsund-hall91806","url":"https:\/\/community.smartsheet.com\/profile\/michelle.farsund-hall91806","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T15:12:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":91806,"lastUser":{"userID":91806,"name":"michelle.farsund-hall91806","url":"https:\/\/community.smartsheet.com\/profile\/michelle.farsund-hall91806","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T15:12:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":79,"score":null,"hot":3372079204,"url":"https:\/\/community.smartsheet.com\/discussion\/106046\/need-help-writing-a-nested-if-if-or-and-if-and-statements","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106046\/need-help-writing-a-nested-if-if-or-and-if-and-statements","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-06T14:57:03+00:00","dateAnswered":"2023-06-06T14:35:39+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":106013,"type":"question","name":"How to I calculate percentage progress in sheet summary based on status?","excerpt":"How to I calculate percentage progress in sheet summary based on status?","categoryID":322,"dateInserted":"2023-06-05T15:26:06+00:00","dateUpdated":"2023-06-05T15:26:43+00:00","dateLastComment":"2023-06-06T14:52:24+00:00","insertUserID":141840,"insertUser":{"userID":141840,"name":"iamje","title":"","url":"https:\/\/community.smartsheet.com\/profile\/iamje","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T13:44:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":150413,"lastUser":{"userID":150413,"name":"Kleerfyre","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kleerfyre","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0FA9VDUULUEH\/n4HMXW6FGST3I.jpg","dateLastActive":"2023-06-07T21:14:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":49,"score":null,"hot":3372044310,"url":"https:\/\/community.smartsheet.com\/discussion\/106013\/how-to-i-calculate-percentage-progress-in-sheet-summary-based-on-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106013\/how-to-i-calculate-percentage-progress-in-sheet-summary-based-on-status","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-06T13:43:26+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"},{"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":105971,"type":"question","name":"IF formula doesn't work?","excerpt":"Hello, I am using an IF formula to generate numbers but it doesn't seem to work when i have numbers over 10,000 and it just spits the same number back out. See below: the formula I am use is: =IF([column 1]@row >= 6500, \"6,500\", [column 1]@row) so I'm trying to get it to say if column 1 is over 6,500 then only write 6,500…","categoryID":322,"dateInserted":"2023-06-02T18:03:13+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T11:42:35+00:00","insertUserID":162036,"insertUser":{"userID":162036,"name":"Jeremy Y O","url":"https:\/\/community.smartsheet.com\/profile\/Jeremy%20Y%20O","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-07T18:39:23+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-06-07T19:38:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":46,"score":null,"hot":3371786748,"url":"https:\/\/community.smartsheet.com\/discussion\/105971\/if-formula-doesnt-work","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105971\/if-formula-doesnt-work","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/WPAB46IEWX2G\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-02T18:12:56+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":105923,"type":"question","name":"Index across sheets","excerpt":"I am attempting a complex formula that will link two SmartSheets. (See below for screenshots) SPAR Review Testing: Uses a form to collect document submissions. This sheet has a submission date column. SPAR Reviewer People Matrix: A people matrix that is used as a schedule showing who is responsible for reviewing the…","categoryID":322,"dateInserted":"2023-06-01T21:13:09+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T11:41:21+00:00","insertUserID":156204,"insertUser":{"userID":156204,"name":"Reese","url":"https:\/\/community.smartsheet.com\/profile\/Reese","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-07T18:05:00+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-06-07T19:38:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":51,"score":null,"hot":3371708670,"url":"https:\/\/community.smartsheet.com\/discussion\/105923\/index-across-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105923\/index-across-sheets","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/J30JLQK58RRO\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-06T09:31:07+00:00","dateAnswered":"2023-06-01T21:29:23+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":105982,"type":"question","name":"I need to result the column's name when using a JOIN(COLLECT) or INDEX(MATCH) formula","excerpt":"Previously, Row 1 of my smartsheet contained the column's name. This way, I could write a JOIN(COLLECT) formula to return the column's name if certain conditions were met throughout the sheet for that row. That worked until we applied column formulas to some of the rows. Now Row 1 can't be the column's name because of the…","categoryID":322,"dateInserted":"2023-06-02T20:43:59+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T11:34:52+00:00","insertUserID":162042,"insertUser":{"userID":162042,"name":"NutritionGal2005","title":"Menu Development and Project Director","url":"https:\/\/community.smartsheet.com\/profile\/NutritionGal2005","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-05T14:02:41+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-06-07T19:38:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":54,"score":null,"hot":3371793531,"url":"https:\/\/community.smartsheet.com\/discussion\/105982\/i-need-to-result-the-columns-name-when-using-a-join-collect-or-index-match-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105982\/i-need-to-result-the-columns-name-when-using-a-join-collect-or-index-match-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-05T14:46:52+00:00","dateAnswered":"2023-06-05T13:25:01+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"},{"tagID":527,"urlcode":"column-where-used","name":"column where used"}],"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":106048,"type":"question","name":"Sumifs formula and isblank?","excerpt":"I'm likely missing something simple. I need a sum where the referenced column is either not \"No\" or if it is blank. The not \"no\" is easy, it works fine. It's incorporating the isblank that is kicking me in the behind. =SUMIFS({FY24 Travel Plan - Department Master Total Cost}, {FY24 Travel Plan - Department Master Range…","categoryID":322,"dateInserted":"2023-06-06T00:47:47+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T01:48:49+00:00","insertUserID":94351,"insertUser":{"userID":94351,"name":"Stephanie Allison","url":"https:\/\/community.smartsheet.com\/profile\/Stephanie%20Allison","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-07T21:36:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":119801,"lastUser":{"userID":119801,"name":"Danielle Arteaga","url":"https:\/\/community.smartsheet.com\/profile\/Danielle%20Arteaga","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/VWN32XC7XJCF\/nCK2EUPRDM1X8.jpg","dateLastActive":"2023-06-07T21:16:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3372029196,"url":"https:\/\/community.smartsheet.com\/discussion\/106048\/sumifs-formula-and-isblank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106048\/sumifs-formula-and-isblank","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/35G2QU0BC2JH\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-06T01:48:49+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":106016,"type":"question","name":"IF CONTAINS Formula to return different text values in second column","excerpt":"Hi! I am looking for some help in creating a formula where if a certain word is found in one column, another word is returned in a second column. For example if \"Head\", \"Nasal\", or \"Spine\" is contained in the Procedure column, \"Neuro\" is returned in the Clinical Specialty column. I've tried different variations of this and…","categoryID":322,"dateInserted":"2023-06-05T17:06:45+00:00","dateUpdated":null,"dateLastComment":"2023-06-05T19:03:23+00:00","insertUserID":141134,"insertUser":{"userID":141134,"name":"Rita ","url":"https:\/\/community.smartsheet.com\/profile\/Rita%20","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-05T19:03:00+00:00","banned":0,"punished":0,"private":true,"label":"✭✭"},"updateUserID":null,"lastUserID":141134,"lastUser":{"userID":141134,"name":"Rita ","url":"https:\/\/community.smartsheet.com\/profile\/Rita%20","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-05T19:03:00+00:00","banned":0,"punished":0,"private":true,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":40,"score":null,"hot":3371977808,"url":"https:\/\/community.smartsheet.com\/discussion\/106016\/if-contains-formula-to-return-different-text-values-in-second-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106016\/if-contains-formula-to-return-different-text-values-in-second-column","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-05T19:02:58+00:00","dateAnswered":"2023-06-05T17:53:11+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}">