Formulas and Functions

=DATE(2023, 7, 1), <=DATE(2023,7,31)) but i think thats something wrong. Thanks for any help","categoryID":322,"dateInserted":"2023-08-17T07:58:48+00:00","dateUpdated":null,"dateLastComment":"2023-08-17T17:53:06+00:00","insertUserID":163782,"insertUser":{"userID":163782,"name":" johann","title":"Sr.","url":"https:\/\/community.smartsheet.com\/profile\/%20johann","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!4ScquMIXUDo!pKjc6UoqrBc!67g8iLwk1n4","dateLastActive":"2023-08-23T19:07:05+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":3,"countViews":46,"score":null,"hot":3384555714,"url":"https:\/\/community.smartsheet.com\/discussion\/109079\/hello-im-looking-for-a-formula-to-count-how-many-rows-i-have-on-items-between-specific-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109079\/hello-im-looking-for-a-formula-to-count-how-many-rows-i-have-on-items-between-specific-dates","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-17T17:43:10+00:00","dateAnswered":"2023-08-17T08:14:30+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":109099,"type":"question","name":"Adding a date range to COUNTIFS","excerpt":"Hello, I need to add a date range to a rollup I created for tracking sales meetings: =COUNTIFS({source sheet customer name}, $[Primary Column]@row, {source sheet dropdown result}, [In Person Meeting]$1) The above works, but is obviously counting the whole sheet, which includes 2 years of data. I tried: =COUNTIFS({source…","categoryID":322,"dateInserted":"2023-08-17T15:05:35+00:00","dateUpdated":null,"dateLastComment":"2023-08-17T17:52:43+00:00","insertUserID":162047,"insertUser":{"userID":162047,"name":"Nat","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Nat","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/TGR5VC4AXHS3\/nABTHIGSKZB11.jpg","dateLastActive":"2023-08-18T17:09:13+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":54,"score":null,"hot":3384581898,"url":"https:\/\/community.smartsheet.com\/discussion\/109099\/adding-a-date-range-to-countifs","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109099\/adding-a-date-range-to-countifs","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-08-17T15:11: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":108999,"type":"question","name":"Systems columns","excerpt":"Hi, I have a form that gathers data. The team works on it and rows change status. Once a row changes to approved, I'd like to move it off to another sheet but my automation is giving me an error - sheet you are moving data too has a systems column of the same name as your original sheet. I have deleted my created by\/date,…","categoryID":322,"dateInserted":"2023-08-15T20:23:00+00:00","dateUpdated":null,"dateLastComment":"2023-08-17T17:51:06+00:00","insertUserID":131821,"insertUser":{"userID":131821,"name":"Melitta","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Melitta","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7FjR-2zeSSY!zOlQs_Tjxjo!J3yyx3hqT9S","dateLastActive":"2023-08-25T17:25:55+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":3,"countViews":50,"score":null,"hot":3384427446,"url":"https:\/\/community.smartsheet.com\/discussion\/108999\/systems-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108999\/systems-columns","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-17T15:21:26+00:00","dateAnswered":"2023-08-15T22:00:50+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":"columns","name":"columns"}],"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":109022,"type":"question","name":"IFERROR and INDEX\/MATCH formula with criteria?","excerpt":"I am using this formula currently on a work document (slightly modified): =IFERROR(INDEX({Assigned Specialist}, MATCH([Project Name]@row, {Project Title}, 0)), \"//www.santa-greenland.com/community/categories/formulas-and-functions/\") Now, what I would like to add is a criteria to this formula that checks the other sheet (the same sheet that Assigned Specialist is on) to see if the Project…","categoryID":322,"dateInserted":"2023-08-16T13:27:14+00:00","dateUpdated":null,"dateLastComment":"2023-08-17T17:50:49+00:00","insertUserID":160760,"insertUser":{"userID":160760,"name":"Jerexify","title":"Knowledge Base Specialist","url":"https:\/\/community.smartsheet.com\/profile\/Jerexify","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-17T18:37:33+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":11,"countViews":94,"score":null,"hot":3384493683,"url":"https:\/\/community.smartsheet.com\/discussion\/109022\/iferror-and-index-match-formula-with-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109022\/iferror-and-index-match-formula-with-criteria","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-17T17:17:40+00:00","dateAnswered":"2023-08-17T12:23: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":109097,"type":"question","name":"Count if singular date falls between a list of date ranges","excerpt":"Hi community, I want to check if a singular date falls between any of a list of different date ranges from another sheet. E.g. If 01\/08\/23 is found in any of a list of start \/ finish date ranges, I want to flag or count. Any suggestions?","categoryID":322,"dateInserted":"2023-08-17T14:59:25+00:00","dateUpdated":null,"dateLastComment":"2023-08-17T17:50:26+00:00","insertUserID":143463,"insertUser":{"userID":143463,"name":"Sam Swain","url":"https:\/\/community.smartsheet.com\/profile\/Sam%20Swain","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T14:51:09+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":5,"countViews":76,"score":null,"hot":3384581991,"url":"https:\/\/community.smartsheet.com\/discussion\/109097\/count-if-singular-date-falls-between-a-list-of-date-ranges","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109097\/count-if-singular-date-falls-between-a-list-of-date-ranges","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-17T16:51:59+00:00","dateAnswered":"2023-08-17T15:08:30+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":109093,"type":"question","name":"Percentage complete with multiple criteria for children","excerpt":"I have child rows with a drop-down that have the following options in the \"Status\" column: Complete, Not Started, In Progress, Blocked, N\/A. In the \"% Complete\" column, I currently have a working formula that updates the percentage complete if a row is marked as \"Complete\". I need the formula to also update the \"%…","categoryID":322,"dateInserted":"2023-08-17T14:34:25+00:00","dateUpdated":"2023-08-17T14:36:27+00:00","dateLastComment":"2023-08-17T17:31:33+00:00","insertUserID":165271,"insertUser":{"userID":165271,"name":"Namaste03","url":"https:\/\/community.smartsheet.com\/profile\/Namaste03","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T16:55:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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":57,"score":null,"hot":3384578158,"url":"https:\/\/community.smartsheet.com\/discussion\/109093\/percentage-complete-with-multiple-criteria-for-children","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109093\/percentage-complete-with-multiple-criteria-for-children","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/SEJCLOIN5MBU\/screenshot.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-08-17T17:02:06+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