Formulas and Functions

=TODAY(-7)","excerpt":"Hi, I have a formula I need help with please, =IF(AND(CONTAINS([Client Name]@row, {Sheet A Range 1}), IF({Sheet A Range 2}, >=TODAY(-7))), \"Match\") ______________ Name = Text column Sheet A Range 1 = Text column Sheet A Range 2 = Date column ______________ Any idea how to correct this #INVALID DATA TYPE? Thank you!","categoryID":322,"dateInserted":"2023-09-14T20:43:47+00:00","dateUpdated":"2023-09-14T21:23:18+00:00","dateLastComment":"2023-09-27T15:05:36+00:00","insertUserID":123243,"insertUser":{"userID":123243,"name":"A Rose","title":"","url":"https:\/\/community.smartsheet.com\/profile\/A%20Rose","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-27T18:01:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":123243,"lastUser":{"userID":123243,"name":"A Rose","title":"","url":"https:\/\/community.smartsheet.com\/profile\/A%20Rose","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-27T18:01:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":113,"score":null,"hot":3390558563,"url":"https:\/\/community.smartsheet.com\/discussion\/110298\/if-and-contains-with-today-7","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110298\/if-and-contains-with-today-7","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-14T22:27:53+00:00","dateAnswered":"2023-09-14T22:27:44+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":110476,"type":"question","name":"COUNTIF + LAST YEAR INFO","excerpt":"=COUNTIFS({M&A Program Interest}, CONTAINS(\"Buyer Consult\", @cell), {M&A Intake Form Range 1}, @cell > YEAR Trying to utilize this formula; pull metrics from the past year only.","categoryID":322,"dateInserted":"2023-09-19T23:03:40+00:00","dateUpdated":null,"dateLastComment":"2023-09-27T15:04:44+00:00","insertUserID":166915,"insertUser":{"userID":166915,"name":"tmagana","url":"https:\/\/community.smartsheet.com\/profile\/tmagana","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-27T14:53:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":166915,"lastUser":{"userID":166915,"name":"tmagana","url":"https:\/\/community.smartsheet.com\/profile\/tmagana","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-27T14:53:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":45,"score":null,"hot":3390994104,"url":"https:\/\/community.smartsheet.com\/discussion\/110476\/countif-last-year-info","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110476\/countif-last-year-info","format":"Rich","groupID":null,"statusID":4,"attributes":{"question":{"status":"rejected","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":110841,"type":"question","name":"Is it possible to change the Source Sheet from Reference instead of individual references ?","excerpt":"Dear Smart Team, How can we modify the Source Sheet name from the Reference instead of modifying individual references. Scenario. I have created more than 50 References use this reference in different formulas. For Example Question and Answer. Reference \"Ans 1\" for Answer 1 and \"Ans 2\" for Answer 1 and so on, till 50th…","categoryID":322,"dateInserted":"2023-09-27T06:07:36+00:00","dateUpdated":null,"dateLastComment":"2023-09-27T14:21:15+00:00","insertUserID":136854,"insertUser":{"userID":136854,"name":"Ibrahim Khaleel","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ibrahim%20Khaleel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n65S9PRP4PA0M.png","dateLastActive":"2023-09-27T06:07:38+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-09-27T17:55:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":13,"score":null,"hot":3391619931,"url":"https:\/\/community.smartsheet.com\/discussion\/110841\/is-it-possible-to-change-the-source-sheet-from-reference-instead-of-individual-references","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110841\/is-it-possible-to-change-the-source-sheet-from-reference-instead-of-individual-references","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/JEDFC6A9MFCX\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-09-27T14:21: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":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":110825,"type":"question","name":"Need a checkbox checked if two items are true \/ Code not working","excerpt":"looking at an item on line that will give me access to everything that is past due or due within the next two weeks on a project schedule. We built a report but it does not give the parent task associated with the child task. I googled and got something similar to what I need but not quite there. Here is what I need: I…","categoryID":322,"dateInserted":"2023-09-26T21:29:34+00:00","dateUpdated":"2023-09-26T21:30:51+00:00","dateLastComment":"2023-09-27T13:56:32+00:00","insertUserID":162256,"insertUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ACg8ocKfkKfhlR3uqOwPWeKsGr1YKov2b3GEBCfVAaaQgcdBkw=s96-c","dateLastActive":"2023-09-27T19:21:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":162256,"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-09-27T17:55:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":23,"score":null,"hot":3391587366,"url":"https:\/\/community.smartsheet.com\/discussion\/110825\/need-a-checkbox-checked-if-two-items-are-true-code-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110825\/need-a-checkbox-checked-if-two-items-are-true-code-not-working","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-27T16:21:35+00:00","dateAnswered":"2023-09-27T13:56:32+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