@angelapaj<\/a> <\/p>Can you try the formula below?<\/p>
=IF(AND([CLIENT TYPE]@row = \"Platinum\", [TOTAL AGING]@row > 1), \"Red\", IF(AND([CLIENT TYPE]@row = \"Gold\", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = \"Not Started\"), \"Red\", IF(AND([CLIENT TYPE]@row = \"Gold\", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = \"Review\"), \"Yellow\", IF(AND([CLIENT TYPE]@row = \"Silver\", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = \"Not Started\"), \"Yellow\", IF(AND([CLIENT TYPE]@row = \"Silver\", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = \"Review\"), \"Yellow\", \"Green\")))))\n<\/pre>"}]}},"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":107304,"type":"question","name":"Formula Help","excerpt":"Hi - I am trying to create a formula that shows the conditions of: Tasks due within the next 14 days that are not equal to the status of \"Complete\" or \"not Required\" I am looking to do this on as a summary total on the project sheet. Thank you for the help!","snippet":"Hi - I am trying to create a formula that shows the conditions of: Tasks due within the next 14 days that are not equal to the status of \"Complete\" or \"not Required\" I am looking…","categoryID":322,"dateInserted":"2023-07-06T19:40:25+00:00","dateUpdated":"2023-07-07T09:23:20+00:00","dateLastComment":"2023-07-07T13:26:13+00:00","insertUserID":163199,"insertUser":{"userID":163199,"name":"Kimberly Starasinich","title":"Senior Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Kimberly%20Starasinich","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!nbb0n90hlLs!zku0MyLT07k!AB0neQYrId5","dateLastActive":"2023-07-07T13:31:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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-07-07T13:25:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":44,"score":null,"hot":3377411798,"url":"https:\/\/community.smartsheet.com\/discussion\/107304\/formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107304\/formula-help","format":"Rich","tagIDs":[254,440],"lastPost":{"discussionID":107304,"commentID":384158,"name":"Re: Formula Help","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384158#Comment_384158","dateInserted":"2023-07-07T13:26:13+00:00","insertUserID":45516,"insertUser":{"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-07-07T13:25:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-07T13:13:59+00:00","dateAnswered":"2023-07-07T13:09:38+00:00","acceptedAnswers":[{"commentID":384147,"body":"Give this a try:<\/p>
=COUNTIFS(Finish:Finish, @cell<= TODAY(14), Status:Status, AND(@cell <> \"Complete\", @cell <> \"Not Required\"))<\/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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
Trending in Formulas and Functions
Previous Month formula Hi I'm in the process of creating MTD and Previous MTD helper columns. If the Create Date is current month, I want to check a box. I have this formula working perfectly. What I'm struggling with is previous MTD. If the Create Date is the previous month, then check a box. If the Create Date is older than previous month,…
Incorrect Argument Set Hi All, I have a formula that worked in one row, but then when I make it a column formula, it shows "incorrect argument set" in all the other rows but the 1st one. Please see below: That's the formula: =IF(AND([CLIENT TYPE]@row = "Platinum", [TOTAL AGING]@row > 1), "Red", IF(AND([CLIENT TYPE]@row = "Gold", [REQUIRED…
Formula Help Hi - I am trying to create a formula that shows the conditions of: Tasks due within the next 14 days that are not equal to the status of "Complete" or "not Required" I am looking to do this on as a summary total on the project sheet. Thank you for the help!
Andrée Starå ✭✭✭✭✭✭
