\n <\/img><\/a>\n <\/div>\n<\/div>\nIf rows are being created when raised only, you can also used the system generated \"Created date\" column, and similarly you can use the \"Modified date\" & slightly modified lock automation if you wanted date time (changed the condition to the status being resolved).<\/p>
Hope this helps, but if you've any questions etc. then just post! 😊<\/span><\/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":319,"urlcode":"functionality","name":"functionality"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]},{"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…","snippet":"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…","categoryID":322,"dateInserted":"2023-08-21T21:09:42+00:00","dateUpdated":null,"dateLastComment":"2023-08-22T14:02: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":163744,"lastUser":{"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":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":27,"score":null,"hot":3385366349,"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","tagIDs":[254],"lastPost":{"discussionID":109237,"commentID":391832,"name":"Re: Using multiple IF(AND) statements in a formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391832#Comment_391832","dateInserted":"2023-08-22T14:02: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":"✭"}},"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,"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":[{"commentID":391743,"body":"Give this a try:<\/p>
=IF(Status@row = \"Complete\", \"Blue\", IF(Status@row = \"In Progress\", IF([End Date]@row< TODAY(), \"Red\", IF([End Date]@row< TODAY(30), \"Yellow\", \"Green\")))<\/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"}]}],"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
How do I solve this UNPARSEABLE error for a cross-sheet SUMIFS formula? I'm attempting to sum a column in another sheet based on matching the product name, the month, and the vendor values in the current sheet but I can't seem to resolve the UNPARSEABLE error. What am I missing? =SUMIFS({Quantity}, {Product}, Product$1, {Month}, Month$1, {Vendor}, Vendor$1)
RAID Log Date Value Locking per column when status changes 你好,每一个one, I have tried to find the best answer for this but I see too many threads and different responses. If anyone could help as I am new to this. I am only looking to lock in a date value on 2 columns whenever there is a status change, from when an issue is raised and then resolved. I know there is a record a…
Using multiple IF(AND) statements in a formula 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…