Formulas

[STR Schematic End]@row, 1, 0)) Above formula meant to trigger a red flag if the WD & STR Schematic End dates do not match. The formula I wrote is pulling back 'invalid' ... I am missing something and cannot figure out what!","categoryID":322,"dateInserted":"2023-08-22T17:45:32+00:00","dateUpdated":null,"dateLastComment":"2023-08-22T18:30:00+00:00","insertUserID":157887,"insertUser":{"userID":157887,"name":"holli.nunn","url":"https:\/\/community.smartsheet.com\/profile\/holli.nunn","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T19:47:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":157887,"lastUser":{"userID":157887,"name":"holli.nunn","url":"https:\/\/community.smartsheet.com\/profile\/holli.nunn","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T19:47:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":42,"score":null,"hot":3385456532,"url":"https:\/\/community.smartsheet.com\/discussion\/109287\/formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109287\/formula-help","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/DLAV2H53BW86\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-22T18:29:34+00:00","dateAnswered":"2023-08-22T18:25:02+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":109248,"type":"question","name":"Formula help: Counting user experience by date","excerpt":"Hi there, I am trying to create a formula to count by user experience (e.g., Positive, negative, Neutral, N\/A) for each month. For example count if a response is in September and it is positive. I am referencing a different sheet and I have tried a few different formulas but I keep getting errors. I am assuming I need to…","categoryID":322,"dateInserted":"2023-08-21T23:06:10+00:00","dateUpdated":null,"dateLastComment":"2023-08-22T18:15:23+00:00","insertUserID":165450,"insertUser":{"userID":165450,"name":"Shep_holly_10 ","url":"https:\/\/community.smartsheet.com\/profile\/Shep_holly_10%20","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-24T22:54:27+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":7,"countViews":48,"score":null,"hot":3385391493,"url":"https:\/\/community.smartsheet.com\/discussion\/109248\/formula-help-counting-user-experience-by-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109248\/formula-help-counting-user-experience-by-date","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/I21IOK10SGM8\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-22T16:57:38+00:00","dateAnswered":"2023-08-22T16:52:33+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":107720,"type":"idea","name":"Find and Replace within Formulas","excerpt":"Would love to be able to Find and Replace within Formulas, would save so much time..","categoryID":349,"dateInserted":"2023-07-18T11:07:22+00:00","dateUpdated":"2023-08-23T10:48:24+00:00","dateLastComment":"2023-08-22T17:58:36+00:00","insertUserID":146974,"insertUser":{"userID":146974,"name":"Jack Parry","url":"https:\/\/community.smartsheet.com\/profile\/Jack%20Parry","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-09T07:01:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":165143,"lastUser":{"userID":165143,"name":"Jessica Limke","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Limke","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtd8xP2QVZaB2Av0MW4IX9nePuVy2vOVta2rdh_umuOKqMA=s96-c","dateLastActive":"2023-08-22T18:10:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":88,"score":6,"hot":3382408558,"url":"https:\/\/community.smartsheet.com\/discussion\/107720\/find-and-replace-within-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107720\/find-and-replace-within-formulas","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"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":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":566,"urlcode":"idea","name":"idea"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":109289,"type":"redirect","name":"Merged: Find and Replace in Formulas Please!!","excerpt":"This discussion has been merged.","categoryID":349,"dateInserted":"2023-08-22T17:58:36+00:00","dateUpdated":"2023-08-23T10:48:32+00:00","dateLastComment":"2023-08-22T17:58:36+00:00","insertUserID":165143,"insertUser":{"userID":165143,"name":"Jessica Limke","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Limke","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtd8xP2QVZaB2Av0MW4IX9nePuVy2vOVta2rdh_umuOKqMA=s96-c","dateLastActive":"2023-08-22T18:10:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":165143,"lastUser":{"userID":165143,"name":"Jessica Limke","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Limke","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtd8xP2QVZaB2Av0MW4IX9nePuVy2vOVta2rdh_umuOKqMA=s96-c","dateLastActive":"2023-08-22T18:10:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":0,"countViews":6,"score":1,"hot":1692727416,"url":"https:\/\/community.smartsheet.com\/discussion\/109289\/merged-find-and-replace-in-formulas-please","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109289\/merged-find-and-replace-in-formulas-please","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":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"}],"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":109269,"type":"question","name":"Nested IF Formula","excerpt":"I would like the IF statement to return a specified value if based upon date ranges. For example, if a date falls within a range: 09\/01\/23 - 11\/30\/23 should return the value \"Q1\" 12\/01\/23 - 02\/29\/24 should return the value \"Q2\" 03\/01\/24 - 05\/31\/24 should return the value \"Q3\" 06\/01\/24 - 08\/31\/24 should return the value…","categoryID":322,"dateInserted":"2023-08-22T15:19:49+00:00","dateUpdated":null,"dateLastComment":"2023-08-22T17:13:22+00:00","insertUserID":163758,"insertUser":{"userID":163758,"name":"Tara_A","title":"Sr IT Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Tara_A","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/2N7F2L8QFMTE\/nVB8FMLXGQZUC.JPG","dateLastActive":"2023-08-23T13:27:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-26T01:04:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":57,"score":null,"hot":3385443791,"url":"https:\/\/community.smartsheet.com\/discussion\/109269\/nested-if-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109269\/nested-if-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-22T16:30:01+00:00","dateAnswered":"2023-08-22T16:10:16+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":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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":109237,"type":"question","name":"Using multiple IF(AND) statements in a formula","excerpt":"Hello, I am trying to create a column formula that will update Schedule health to a red, yellow, green, or blue circle using multiple IF and IF(AND) statements, but I continuously get the error message \"#INCORRECT ARGUMENT SET\" Here is my formula: =IF(IF(AND([End Date]@row - [Today's Date]@row <= 0, Status@row = \"In…","categoryID":322,"dateInserted":"2023-08-21T21:09:42+00:00","dateUpdated":null,"dateLastComment":"2023-08-22T16:06:47+00:00","insertUserID":163744,"insertUser":{"userID":163744,"name":"AdamsR","title":"Regulatory and Development Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/AdamsR","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-22T14:37:48+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":3,"countViews":44,"score":null,"hot":3385374389,"url":"https:\/\/community.smartsheet.com\/discussion\/109237\/using-multiple-if-and-statements-in-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109237\/using-multiple-if-and-statements-in-a-formula","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/HIPWQ63RW1TU\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-22T14:01:52+00:00","dateAnswered":"2023-08-21T22:21: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":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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">