Formulas and Functions

[Temp Move 1 Move In Date]@row, TODAY() <= [Temp Move 1 Move Out Date]@row), \"Temp Move 1\", \"Not Temp Move 1\")) The column…","categoryID":322,"dateInserted":"2020-10-15T20:36:32+00:00","dateUpdated":null,"dateLastComment":"2020-10-15T21:07:53+00:00","insertUserID":125123,"insertUser":{"userID":125123,"name":"Bethany Garcia","url":"https:\/\/community.smartsheet.com\/profile\/Bethany%20Garcia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-13T17:51:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":125123,"lastUser":{"userID":125123,"name":"Bethany Garcia","url":"https:\/\/community.smartsheet.com\/profile\/Bethany%20Garcia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-13T17:51:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":223,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/72292\/check-if-today-is-in-between-the-date-in-two-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72292\/check-if-today-is-in-between-the-date-in-two-cells","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-15T21:07:58+00:00","dateAnswered":"2020-10-15T20:45:51+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":71871,"type":"question","name":"Nesting INDEX\/MATCH","excerpt":"Here's a pretty version of the formula I'm trying to implement: I can nest two INDEX\/MATCHs and it works fine: =IFERROR(IFERROR(INDEX({CA Region Review Range 1}, MATCH([RE Store # Lookup]@row, {CA Region Review Range 2}, 0)), INDEX({Carolinas Region Review Range 1}, MATCH([RE Store # Lookup]@row, {Carolinas Region Review…","categoryID":322,"dateInserted":"2020-10-02T23:37:57+00:00","dateUpdated":null,"dateLastComment":"2020-10-15T20:49:57+00:00","insertUserID":119882,"insertUser":{"userID":119882,"name":"Robert Francher","url":"https:\/\/community.smartsheet.com\/profile\/Robert%20Francher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-30T17:24:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":119882,"lastUser":{"userID":119882,"name":"Robert Francher","url":"https:\/\/community.smartsheet.com\/profile\/Robert%20Francher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-30T17:24:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":378,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/71871\/nesting-index-match","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71871\/nesting-index-match","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/84DXCY7KIL1K\/formula.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"formula.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-15T20:50:08+00:00","dateAnswered":"2020-10-15T20:49:57+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":72071,"type":"question","name":"Need help with a formula","excerpt":"I need to be able to track when an employee needs a certificate of disability. A COD is required on the 4th sick occurrence recorded. An occurrence is defined as either 1 day OR 1 set of days that are consecutive. For example if I call off Mon-Wed, that is one occurrence. But if I call off Monday, come back Tuesday, and…","categoryID":322,"dateInserted":"2020-10-09T11:45:22+00:00","dateUpdated":null,"dateLastComment":"2020-10-15T20:48:58+00:00","insertUserID":127399,"insertUser":{"userID":127399,"name":"Tim Copeland","url":"https:\/\/community.smartsheet.com\/profile\/Tim%20Copeland","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-15T20:45:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":127399,"lastUser":{"userID":127399,"name":"Tim Copeland","url":"https:\/\/community.smartsheet.com\/profile\/Tim%20Copeland","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-15T20:45:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":61,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/72071\/need-help-with-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72071\/need-help-with-a-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-15T20:46:38+00:00","dateAnswered":"2020-10-09T18:39:35+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":72287,"type":"question","name":"Auto Date Calculation\/Auto Fill Date","excerpt":"Hello, I would like the \"Referral Bonus Payout Date\" to return a date that is 90 days out from today once the \"Referral Bonus Amount\" and \"Referred By\" fields are filled in. Is it possible? Please advise. Thank you!","categoryID":322,"dateInserted":"2020-10-15T19:06:11+00:00","dateUpdated":"2020-10-15T19:26:24+00:00","dateLastComment":"2020-10-15T20:41:54+00:00","insertUserID":101291,"insertUser":{"userID":101291,"name":"styless","url":"https:\/\/community.smartsheet.com\/profile\/styless","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!-sjCtwkkFLY!5RDCOalHb2Y!nLZJRZoSkx4","dateLastActive":"2022-09-20T18:27:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":101291,"lastUserID":120260,"lastUser":{"userID":120260,"name":"David Tutwiler","title":"","url":"https:\/\/community.smartsheet.com\/profile\/David%20Tutwiler","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GiIpuCpV7Zvo9nduJmLt8ULNYObTVazzemdnIiy6w=s96-c","dateLastActive":"2023-08-17T18:49:54+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers Alumni"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":53,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/72287\/auto-date-calculation-auto-fill-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72287\/auto-date-calculation-auto-fill-date","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/40B1ANGMVNFD\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-15T20:37:46+00:00","dateAnswered":"2020-10-15T20:34:14+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":72286,"type":"question","name":"VLOOKUP question","excerpt":"Hi everyone, I have two sheets, the first picture shows the columns in my sheet. It is a large table. Their are only 16 Superintendents, but over 1,000 principals. The second picture is my second sheet, I use this in card view. The idea is that we search a school and poof the super\/principal and other contact info appear.…","categoryID":322,"dateInserted":"2020-10-15T19:02:22+00:00","dateUpdated":null,"dateLastComment":"2020-10-15T19:57:14+00:00","insertUserID":125387,"insertUser":{"userID":125387,"name":"Lila De Vera","url":"https:\/\/community.smartsheet.com\/profile\/Lila%20De%20Vera","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BqDeQW6uPGY!wx9f_6KbvvQ!zYdjWnf2PiH","dateLastActive":"2021-10-29T17:42:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":125387,"lastUser":{"userID":125387,"name":"Lila De Vera","url":"https:\/\/community.smartsheet.com\/profile\/Lila%20De%20Vera","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BqDeQW6uPGY!wx9f_6KbvvQ!zYdjWnf2PiH","dateLastActive":"2021-10-29T17:42:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":71,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/72286\/vlookup-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72286\/vlookup-question","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/KSBUX0LBOWZC\/capture-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.PNG"},"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":72283,"type":"question","name":"Automate checking a box if date column is less than 2 weeks?","excerpt":"I have a check box column (can be changed to symbol if needed), and Id like the box to check if the date in another column is less than 2 weeks from the current date. What would the formula be? Thank you!","categoryID":322,"dateInserted":"2020-10-15T18:51:20+00:00","dateUpdated":null,"dateLastComment":"2020-10-15T19:21:54+00:00","insertUserID":111081,"insertUser":{"userID":111081,"name":"brianne111081","url":"https:\/\/community.smartsheet.com\/profile\/brianne111081","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2T9cPlGCs_w!W2dcn1BmWjw!-qOv6zZN1n6","dateLastActive":"2022-10-27T16:55:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":119014,"lastUser":{"userID":119014,"name":"Kelly Drake","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Drake","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/2S3BS3UA017T\/n78P8XVGIT7NW.jpeg","dateLastActive":"2023-08-16T21:37:09+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers Alumni"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":315,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72283\/automate-checking-a-box-if-date-column-is-less-than-2-weeks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72283\/automate-checking-a-box-if-date-column-is-less-than-2-weeks","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-15T20:40:44+00:00","dateAnswered":"2020-10-15T19:21:54+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":334,"urlcode":"automations","name":"Automations"}],"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":72278,"type":"question","name":"Hi, i'm trying to do a simple COUNTIF for one column, to see how many of each group exist","excerpt":"I'm trying to pull how many of each group are listed in the column Current Owner, and keep returning a message of #blocked. =COUNTIFS([Current Owner]:[Current Owner], \"PDT\", \"Team Healy\") Thoughts?","categoryID":322,"dateInserted":"2020-10-15T17:54:03+00:00","dateUpdated":null,"dateLastComment":"2020-10-15T19:02:31+00:00","insertUserID":127631,"insertUser":{"userID":127631,"name":"Mercedes Draffin","url":"https:\/\/community.smartsheet.com\/profile\/Mercedes%20Draffin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-11-04T12:20:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":121748,"lastUser":{"userID":121748,"name":"John Jonassen","url":"https:\/\/community.smartsheet.com\/profile\/John%20Jonassen","photoUrl":"https:\/\/lh4.googleusercontent.com\/-HbmjQRv-LuA\/AAAAAAAAAAI\/AAAAAAAAAAA\/AMZuuck6Pa_uek-ruwL0UKJCEr3XppYqFw\/photo.jpg","dateLastActive":"2022-10-05T18:31:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":64,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72278\/hi-im-trying-to-do-a-simple-countif-for-one-column-to-see-how-many-of-each-group-exist","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72278\/hi-im-trying-to-do-a-simple-countif-for-one-column-to-see-how-many-of-each-group-exist","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":72237,"type":"question","name":"IF(AND) Function - INCORRECT ARGUMENT","excerpt":"I am trying to enter a value in a column based on the data in other columns. This first part of the formula works just fine. I am basically comparing the value in one field to a value in a helper cell. THIS PART WORKS: =IF(AND([Surg Cogn Comp (copy)]@row < [Helper Value]5, [Surg Perf Comp (copy)]@row < [Helper Value]6),…","categoryID":322,"dateInserted":"2020-10-14T20:56:17+00:00","dateUpdated":null,"dateLastComment":"2020-10-15T19:01:55+00:00","insertUserID":121065,"insertUser":{"userID":121065,"name":"Lynn Meadow","url":"https:\/\/community.smartsheet.com\/profile\/Lynn%20Meadow","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!XJdW31NuC7w!nhtXf4c_Fno!mesWdJDvWXc","dateLastActive":"2023-01-28T21:54:22+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-19T18:57:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":114,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/72237\/if-and-function-incorrect-argument","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72237\/if-and-function-incorrect-argument","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-15T18:58:04+00:00","dateAnswered":"2020-10-15T16:32:12+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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Help Article Resources