使用RYGB球嵌套IF语句
嗨，我试图设置一个嵌套的IF语句来做以下事情:
如果选中DONE，则将Status更改为蓝色。
如果到期日期超过8天，那么将其设置为绿色。
如果到期日期为7天或更短，则将其标记为黄色。
如果截止日期是今天或过去，请将其标记为红色。
这是我到目前为止所拥有的，但它不起作用。
=如果(Done1 = 1,“蓝色”,如果([日期]1 < > =今天(7),“绿色”,如果([日期]1 >今天(8),“黄色”,如果([日期]1 > =今天(0),“红色”))))
任何帮助都将非常感激。
评论
-
Brian W ✭✭
你就快到了，但你的计算有一点误差。试试这个:
=如果(Done1 = 1,“蓝色”,如果([日期]1 >今天(8),“绿色”,如果([日期]1 >今天(),“黄”、“红”)))
帮助文章参考资料欧宝体育app官方888
类别
<\/p>
You can have a formula in AFO Version and make it a column formula. The formula would be \"=Right([Primary Column]@row, 4)\". This formula will pick up the last 4 characters of the text in your primary column.<\/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":106523,"type":"question","name":"SUMIF formula not working, can't see why...","excerpt":"I've been messing with this for an hour and going crazy. Can anyone see the problem? Or suggest an alternative formula? The formula =SUMIF({8. FY24 FSS Travel Tracking Total Cost}, Appropriation@row, {8. FY24 FSS Travel Tracking Log ARU}) It is located in the cell that's been circled. It is referencing columns on this…","categoryID":322,"dateInserted":"2023-06-15T19:58:37+00:00","dateUpdated":null,"dateLastComment":"2023-06-15T21:02:57+00:00","insertUserID":94351,"insertUser":{"userID":94351,"name":"Stephanie Allison","url":"https:\/\/community.smartsheet.com\/profile\/Stephanie%20Allison","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T20:59:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":94351,"lastUser":{"userID":94351,"name":"Stephanie Allison","url":"https:\/\/community.smartsheet.com\/profile\/Stephanie%20Allison","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T20:59:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"score":null,"hot":3373723894,"url":"https:\/\/community.smartsheet.com\/discussion\/106523\/sumif-formula-not-working-cant-see-why","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106523\/sumif-formula-not-working-cant-see-why","format":"Rich","lastPost":{"discussionID":106523,"commentID":380931,"name":"Re: SUMIF formula not working, can't see why...","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380931#Comment_380931","dateInserted":"2023-06-15T21:02:57+00:00","insertUserID":94351,"insertUser":{"userID":94351,"name":"Stephanie Allison","url":"https:\/\/community.smartsheet.com\/profile\/Stephanie%20Allison","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T20:59:23+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/ONQHHA6AMB9R\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-15T21:02:05+00:00","dateAnswered":"2023-06-15T20:24:11+00:00","acceptedAnswers":[{"commentID":380897,"body":"
