@Nicole V<\/a> <\/p>Please try this - presuming you are inserting the formula on rows 13-15 in the Total column of your screenshot:<\/p>
=SUMIFS(Total$2:Total$9, Variable$2:Variable$9, CONTAINS(Variable@row, @cell))<\/p>
Hope this helps!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":106200,"type":"question","name":"How do I automatically calculate a due date based on the timeframe a form has been submitted?","excerpt":"Some background: I receive requests for funding through a form that then auto-populates into my sheet. On the first of every month, 3 individuals receive an email notifying them that the applications from the previous month are available for review. The due date to review them is the one week from the day they get the…","categoryID":322,"dateInserted":"2023-06-08T14:51:16+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T15:36:26+00:00","insertUserID":162194,"insertUser":{"userID":162194,"name":"Faith","url":"https:\/\/community.smartsheet.com\/profile\/Faith","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYH2KVOSzmj2vhmfD_q8s6DrUSZWCbalNMPPcnr=s96-c","dateLastActive":"2023-06-08T15:35:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162194,"lastUser":{"userID":162194,"name":"Faith","url":"https:\/\/community.smartsheet.com\/profile\/Faith","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYH2KVOSzmj2vhmfD_q8s6DrUSZWCbalNMPPcnr=s96-c","dateLastActive":"2023-06-08T15:35:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":30,"score":null,"hot":3372476862,"url":"https:\/\/community.smartsheet.com\/discussion\/106200\/how-do-i-automatically-calculate-a-due-date-based-on-the-timeframe-a-form-has-been-submitted","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106200\/how-do-i-automatically-calculate-a-due-date-based-on-the-timeframe-a-form-has-been-submitted","format":"Rich","lastPost":{"discussionID":106200,"commentID":379633,"name":"Re: How do I automatically calculate a due date based on the timeframe a form has been submitted?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379633#Comment_379633","dateInserted":"2023-06-08T15:36:26+00:00","insertUserID":162194,"insertUser":{"userID":162194,"name":"Faith","url":"https:\/\/community.smartsheet.com\/profile\/Faith","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxYH2KVOSzmj2vhmfD_q8s6DrUSZWCbalNMPPcnr=s96-c","dateLastActive":"2023-06-08T15:35:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-08T15:35:54+00:00","dateAnswered":"2023-06-08T15:30:29+00:00","acceptedAnswers":[{"commentID":379622,"body":"
Ok. SO the 7th of the month after submission would look something like this (in a Date type column):<\/p>
=DATE(YEAR([Submission Date]@row) + IF(MONTH([Submission Date]@row) = 12, 1, 0), IF(MONTH([Submission Date]@row) = 12, 1, MONTH([Submission Date]@row) + 1), 7)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":106193,"type":"question","name":"Multiple Forms, One Smartsheet","excerpt":"I created two identical forms (except for the name) and both of them populated into the same smartsheet. Is there a way to only see one form's submissions?","categoryID":321,"dateInserted":"2023-06-08T13:28:04+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T13:47:26+00:00","insertUserID":152102,"insertUser":{"userID":152102,"name":"AllieB","url":"https:\/\/community.smartsheet.com\/profile\/AllieB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T13:49:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":66106,"lastUser":{"userID":66106,"name":"Peggy Parchert","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Parchert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/YYRDMWWFX83G\/nC7HLGW82ACPT.jpg","dateLastActive":"2023-06-08T16:12:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":41,"score":null,"hot":3372467730,"url":"https:\/\/community.smartsheet.com\/discussion\/106193\/multiple-forms-one-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106193\/multiple-forms-one-smartsheet","format":"Rich","lastPost":{"discussionID":106193,"commentID":379551,"name":"Re: Multiple Forms, One Smartsheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379551#Comment_379551","dateInserted":"2023-06-08T13:47:26+00:00","insertUserID":66106,"insertUser":{"userID":66106,"name":"Peggy Parchert","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Parchert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/YYRDMWWFX83G\/nC7HLGW82ACPT.jpg","dateLastActive":"2023-06-08T16:12:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-08T13:46:06+00:00","dateAnswered":"2023-06-08T13:44:25+00:00","acceptedAnswers":[{"commentID":379548,"body":"
@AllieB<\/a> <\/p>Yes - in your sheet, add a Created date column.<\/p>
-Peggy<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
Alina安德森 员工
Jaye Casciano ✭✭✭✭✭✭
