Formulas

=DATE(IF(MONTH(TODAY())>=7, YEAR(TODAY()), YEAR(TODAY())-1), 7, 1), {Consumer Alerts Sign-up Form Date}, <=DATE(IF(MONTH(TODAY())>=7, YEAR(TODAY())+1, YEAR(TODAY())), 7, 31), {Consumer Alerts Sign-up Form Range 1}, @cell = \"\") I am trying to create a COUNTIFS formula for each…","categoryID":322,"dateInserted":"2023-05-23T13:43:46+00:00","dateUpdated":null,"dateLastComment":"2023-05-25T13:33:43+00:00","insertUserID":161705,"insertUser":{"userID":161705,"name":"Christina S.","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T18:07:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161705,"lastUser":{"userID":161705,"name":"Christina S.","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T18:07:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":103,"score":null,"hot":3369875849,"url":"https:\/\/community.smartsheet.com\/discussion\/105579\/what-is-wrong-with-this-countifs-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105579\/what-is-wrong-with-this-countifs-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-23T17:45:53+00:00","dateAnswered":"2023-05-23T15:11: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":204,"urlcode":"Forms","name":"Forms"},{"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":105630,"type":"question","name":"Formula to sum values based on multiple cells.","excerpt":"Hi All, I am managing a material tracking sheet and I need a little bit of help with the following: I need a formula (or some method) to sum values of cells in a column called 'Qty'' based on the info in 3 other columns. So the formula will find all the rows with where the PO No. cells match and the Material Description…","categoryID":322,"dateInserted":"2023-05-24T08:54:04+00:00","dateUpdated":null,"dateLastComment":"2023-05-25T13:03:04+00:00","insertUserID":15196,"insertUser":{"userID":15196,"name":"Brian Hassett","url":"https:\/\/community.smartsheet.com\/profile\/Brian%20Hassett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-31T14:42:43+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-09T23:38:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":87,"score":null,"hot":3369942428,"url":"https:\/\/community.smartsheet.com\/discussion\/105630\/formula-to-sum-values-based-on-multiple-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105630\/formula-to-sum-values-based-on-multiple-cells","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-24T16:06:30+00:00","dateAnswered":"2023-05-24T14:14:21+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":93245,"type":"redirect","name":"Merged: Automation Action to calculate a Variable Value","excerpt":"This discussion has been merged.","categoryID":349,"dateInserted":"2022-07-14T23:55:17+00:00","dateUpdated":"2023-05-25T12:17:34+00:00","dateLastComment":"2023-05-25T12:17:10+00:00","insertUserID":137089,"insertUser":{"userID":137089,"name":"Adrian @ Chess","title":"Managing Director","url":"https:\/\/community.smartsheet.com\/profile\/Adrian%20%40%20Chess","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/Q3AKFSIMT4LI\/n46GTRXZF0SQ2.png","dateLastActive":"2023-06-09T04:46:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":137089,"lastUser":{"userID":137089,"name":"Adrian @ Chess","title":"Managing Director","url":"https:\/\/community.smartsheet.com\/profile\/Adrian%20%40%20Chess","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/Q3AKFSIMT4LI\/n46GTRXZF0SQ2.png","dateLastActive":"2023-06-09T04:46:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":0,"countViews":99,"score":1,"hot":1657843217,"url":"https:\/\/community.smartsheet.com\/discussion\/93245\/merged-automation-action-to-calculate-a-variable-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93245\/merged-automation-action-to-calculate-a-variable-value","format":"Html","groupID":null,"statusID":10000,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}],"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":71108,"type":"question","name":"Find Difference between two Cells that could be Multiselect Dropdowns or Text","excerpt":"I am pretty advanced when it comes to smartsheet and formulas. But this one has me stumped. I am trying to find a way to report on the difference between two text or multiselect cells. Any advice would be much appreciated.","categoryID":322,"dateInserted":"2020-09-04T18:06:28+00:00","dateUpdated":null,"dateLastComment":"2023-05-25T11:17:15+00:00","insertUserID":125792,"insertUser":{"userID":125792,"name":"Thomas Bostwick","url":"https:\/\/community.smartsheet.com\/profile\/Thomas%20Bostwick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-30T18:32:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":148260,"lastUser":{"userID":148260,"name":"Mohamed ","url":"https:\/\/community.smartsheet.com\/profile\/Mohamed%20","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-30T10:59:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":13,"countViews":391,"score":null,"hot":3284264023,"url":"https:\/\/community.smartsheet.com\/discussion\/71108\/find-difference-between-two-cells-that-could-be-multiselect-dropdowns-or-text","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71108\/find-difference-between-two-cells-that-could-be-multiselect-dropdowns-or-text","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-09-04T18:19:15+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":265,"urlcode":"Reports","name":"Reports"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":105662,"type":"question","name":"Do formulas not work in automation?","excerpt":"I'm trying to make new rows copy the cell in a column under a parent but this doesn't seem to function. Am I missing something? When I run this, it posts '=Parent() which doesn't help me.","categoryID":321,"dateInserted":"2023-05-24T18:37:55+00:00","dateUpdated":"2023-05-24T18:43:56+00:00","dateLastComment":"2023-05-24T22:00:48+00:00","insertUserID":159811,"insertUser":{"userID":159811,"name":"Album","url":"https:\/\/community.smartsheet.com\/profile\/Album","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BE1XgYNCIEQ!m2jQ_wi7XbQ!hcjCd37MUgo","dateLastActive":"2023-06-05T12:50:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"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-10T03:29:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":70,"score":null,"hot":3369922723,"url":"https:\/\/community.smartsheet.com\/discussion\/105662\/do-formulas-not-work-in-automation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105662\/do-formulas-not-work-in-automation","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/XP2PM1Q5FIDR\/screenshot-2023-05-24-143543.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-05-24 143543.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-24T20:16:06+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">