Formulas and Functions

TODAY(+7), @cell <= TODAY(+14))) This give me a 1 or 0 result so I can count them, great! How can I change the formula so that I know what the DATES are…","categoryID":322,"dateInserted":"2020-09-29T23:00:56+00:00","dateUpdated":null,"dateLastComment":"2020-10-01T21:39:35+00:00","insertUserID":118808,"insertUser":{"userID":118808,"name":"Jeana","url":"https:\/\/community.smartsheet.com\/profile\/Jeana","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3QlV_6dMjzo!xBjVsS93JyY!3ztBNjGJ7bu","dateLastActive":"2023-03-28T01:37:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":118808,"lastUser":{"userID":118808,"name":"Jeana","url":"https:\/\/community.smartsheet.com\/profile\/Jeana","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3QlV_6dMjzo!xBjVsS93JyY!3ztBNjGJ7bu","dateLastActive":"2023-03-28T01:37:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":71,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/71710\/how-to-add-dates-to-formula-using-today-7-etc","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71710\/how-to-add-dates-to-formula-using-today-7-etc","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":71802,"type":"question","name":"Counting Rows with multiple contact columns","excerpt":"I need to know how to count a row if a specific user is in ANY of 3 contact columns in a specific row with the possibility of multiple users - HELP😫 =COUNTIF(OR({ProgMgr}, CONTAINS(\"Bob\", @cell), {ProjMgr}, CONTAINS(\"bob\", @cell), {ChMgr}, CONTAINS(\"bob\", @cell))","categoryID":322,"dateInserted":"2020-10-01T18:37:34+00:00","dateUpdated":null,"dateLastComment":"2020-10-01T21:30:14+00:00","insertUserID":68536,"insertUser":{"userID":68536,"name":"Danielle Roach","url":"https:\/\/community.smartsheet.com\/profile\/Danielle%20Roach","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-26T22:07:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"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-06-29T19:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":71,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/71802\/counting-rows-with-multiple-contact-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71802\/counting-rows-with-multiple-contact-columns","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/KLI61KFJCXCK\/screen-shot-2020-10-01-at-12-34-49-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2020-10-01 at 12.34.49 PM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-02-25T22:51:57+00:00","dateAnswered":"2020-10-01T21:30: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":[],"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":71741,"type":"question","name":"Based on a closed date and a remaining budget can I figure what the monthly spend should be","excerpt":"I want to be able to caluculate based on the contract closed date of a project \/ remaining budget what will the monthly spend be?","categoryID":322,"dateInserted":"2020-09-30T19:51:03+00:00","dateUpdated":null,"dateLastComment":"2020-10-01T21:09:40+00:00","insertUserID":119617,"insertUser":{"userID":119617,"name":"Lori Cross","url":"https:\/\/community.smartsheet.com\/profile\/Lori%20Cross","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!CSFVgud28_o!cznV59tI-rw!EebRnd7YrNT","dateLastActive":"2023-06-30T15:48:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":119617,"lastUser":{"userID":119617,"name":"Lori Cross","url":"https:\/\/community.smartsheet.com\/profile\/Lori%20Cross","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!CSFVgud28_o!cznV59tI-rw!EebRnd7YrNT","dateLastActive":"2023-06-30T15:48:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":51,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/71741\/based-on-a-closed-date-and-a-remaining-budget-can-i-figure-what-the-monthly-spend-should-be","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71741\/based-on-a-closed-date-and-a-remaining-budget-can-i-figure-what-the-monthly-spend-should-be","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-01T21:09:18+00:00","dateAnswered":"2020-10-01T14:31:29+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":71733,"type":"question","name":"Using nested INDEX\/MATCH","excerpt":"I'm trying to nest an INDEX\/MATCH to search multiple sheets for a unique Store #. In my test, I'm only trying to search two different sheets but eventually will need to look in 10 different places. I looked at a previous posting and tried to duplicate the same but I'm getting #UNPARASABLE Here's what I tried:…","categoryID":322,"dateInserted":"2020-09-30T16:56:19+00:00","dateUpdated":null,"dateLastComment":"2020-10-01T20:38:08+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":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-06-30T20:11:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":142,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/71733\/using-nested-index-match","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71733\/using-nested-index-match","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/3VTVVJU99QSC\/formula-test.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"formula-test.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-01T20:34:54+00:00","dateAnswered":"2020-10-01T19:51:05+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":71806,"type":"question","name":"Cell Formula for @ Row","excerpt":"I love the new capability of the Cell Formula @ Row. How would you get a total for that row? I tried doing it in another row using =([CALC - Attendance]@row:[CALC - Attendance]@row). I come back with #circular Reference.","categoryID":322,"dateInserted":"2020-10-01T19:08:28+00:00","dateUpdated":null,"dateLastComment":"2020-10-01T19:32:12+00:00","insertUserID":81751,"insertUser":{"userID":81751,"name":"Lori Leighton","url":"https:\/\/community.smartsheet.com\/profile\/Lori%20Leighton","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-49ft9BEInw!4cDYOE1TTNY!weLUSUrkXuD","dateLastActive":"2023-06-06T23:49:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":81751,"lastUser":{"userID":81751,"name":"Lori Leighton","url":"https:\/\/community.smartsheet.com\/profile\/Lori%20Leighton","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-49ft9BEInw!4cDYOE1TTNY!weLUSUrkXuD","dateLastActive":"2023-06-06T23:49:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":61,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/71806\/cell-formula-for-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71806\/cell-formula-for-row","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":71697,"type":"question","name":"Sum total minutes at a particular data center over the last twelve full months","excerpt":"Hi, Been trying to figure this out for awhile. Here's my issue: I am trying to create a rolling sum of the minutes that there is an outage at a particular data center over the last 12 complete months (not including the current month) by referencing another sheet in Smartsheet. We eventually want this number to update…","categoryID":322,"dateInserted":"2020-09-29T18:11:32+00:00","dateUpdated":null,"dateLastComment":"2020-10-01T19:24:18+00:00","insertUserID":126804,"insertUser":{"userID":126804,"name":"Kelly McLaughlin","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20McLaughlin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-22T18:26:28+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-06-30T20:11:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":81,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/71697\/sum-total-minutes-at-a-particular-data-center-over-the-last-twelve-full-months","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71697\/sum-total-minutes-at-a-particular-data-center-over-the-last-twelve-full-months","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":[{"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":71535,"type":"question","name":"Using SUM and COLLECT To Get a Total","excerpt":"I have 3 sheets total with the same columns; Identifier, Quantity, Status. Sheet 1 has a form that collects supply request from a business unit; a user selects the supply needed as well as the quantity of the needed. A field named Status is used to determine if the supply has left inventory (SHIPPED). Sheet 2 has a form to…","categoryID":322,"dateInserted":"2020-09-23T22:12:59+00:00","dateUpdated":null,"dateLastComment":"2020-10-01T19:22:45+00:00","insertUserID":97141,"insertUser":{"userID":97141,"name":"cthrasher97141","url":"https:\/\/community.smartsheet.com\/profile\/cthrasher97141","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-12\/8a\/0e\/n8a0e1d2c7c282c2f8e1ba6250c4a137b.jpg","dateLastActive":"2023-06-13T22:47:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":97141,"lastUser":{"userID":97141,"name":"cthrasher97141","url":"https:\/\/community.smartsheet.com\/profile\/cthrasher97141","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-12\/8a\/0e\/n8a0e1d2c7c282c2f8e1ba6250c4a137b.jpg","dateLastActive":"2023-06-13T22:47:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":813,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/71535\/using-sum-and-collect-to-get-a-total","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71535\/using-sum-and-collect-to-get-a-total","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":71791,"type":"question","name":"IF\/OR Function Help","excerpt":"Hi there! I'm working on a basic IF\/OR formula and am hoping another set of eyes might help me see why I'm getting an unparseable error. I'm looking for a way to evaluate 2 cells and when either show an \"approved\" status it sets a checkbox to true, otherwise leaves it as false. More specifically, if BLC Approval OR CoS…","categoryID":322,"dateInserted":"2020-10-01T18:08:07+00:00","dateUpdated":null,"dateLastComment":"2020-10-01T18:14:30+00:00","insertUserID":123985,"insertUser":{"userID":123985,"name":"Amy Gutirrez","url":"https:\/\/community.smartsheet.com\/profile\/Amy%20Gutirrez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-21T19:51:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-06-29T19:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":51,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/71791\/if-or-function-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71791\/if-or-function-help","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/ZAZAD3JCQYOZ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Help Article Resources