黄色RAG公式:在2个数字之间(大于小于)

Kaleb · 07/28/22

问候Smartsheet社区:

我需要在我的公式中添加一个范围-9 & -1变成黄色。谢谢

当前的公式:

=IF(或([附表差异]@row > 0，[附表差异]@row = 0)， "绿色"，IF([附表差异]@row <= -10， "红色")))

杰森的杜 · 07/29/22

试试这个。我通常会先在嵌套的IF中检查ISBLANK，然后检查Schedule Variance的条件。IF语句中的逻辑可能有点奇怪，需要一些练习。我建议在他们的在线帮助中阅读IF函数。

https://help.smartsheet.com/function/if

对于IF语句和正在使用的任何其他函数(如ISBLANK)，都必须小心括号的位置。

=IF(ISBLANK([附表差异]@row)， "灰色"，IF([附表差异]@row >= 0， "绿色"，IF([附表差异]@row <= -10， "红色"，"黄色"))))

Kaleb · 07/29/22

Try this. I would usually put the checks for ISBLANK first in the nested IF, then check the conditions for the Schedule Variance. The logic in IF statements can be a little weird and take some practice. I'd suggest reading up on the IF function in their online help.<\/p>

https:\/\/help.smartsheet.com\/function\/if<\/a><\/p>

You have to be careful with placement of the parenthesis for both the IF statement and any other functions like ISBLANK that you're using.<\/p>

=IF(ISBLANK([Schedule Variance]@row), "Gray", IF([Schedule Variance]@row >= 0, "Green", IF([Schedule Variance]@row <= -10, "Red", "Yellow")))<\/p>","bodyRaw":"[{\"insert\":\"Try this. I would usually put the checks for ISBLANK first in the nested IF, then check the conditions for the Schedule Variance. The logic in IF statements can be a little weird and take some practice. I'd suggest reading up on the IF function in their online help.\\n\"},{\"insert\":\"https:\\\/\\\/help.smartsheet.com\\\/function\\\/if\",\"attributes\":{\"link\":\"https:\\\/\\\/help.smartsheet.com\\\/function\\\/if\"}},{\"insert\":\"\\n\"},{\"insert\":\"You have to be careful with placement of the parenthesis for both the IF statement and any other functions like ISBLANK that you're using.\\n=IF(ISBLANK([Schedule Variance]@row), \\\"Gray\\\", IF([Schedule Variance]@row >= 0, \\\"Green\\\", IF([Schedule Variance]@row <= -10, \\\"Red\\\", \\\"Yellow\\\")))\\n\"}]","format":"rich","dateInserted":"2022-07-29T13:01:37+00:00","insertUser":{"userID":115749,"name":"Jason Duryea","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20Duryea","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AFdZucoN485Er-68imH5a6nIxiSUecQ96Py8krC4N2-LQQ=s96-c","dateLastActive":"2022-09-21T11:15:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/337950#Comment_337950","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/337950#Comment_337950

太好了，成功了!谢谢

杰森的杜 · 07/28/22

=IF([附表差异]@row >= 0， "绿色"，IF([附表差异]@row <= -10， "红色"，"黄色"))

Kaleb · 07/29/22

=IF([Schedule Variance]@row >= 0, "Green", IF([Schedule Variance]@row <= -10, "Red", “Yellow”))<\/p>","bodyRaw":"[{\"insert\":\"=IF([Schedule Variance]@row >= 0, \\\"Green\\\", IF([Schedule Variance]@row <= -10, \\\"Red\\\", “Yellow”))\\n\"}]","format":"rich","dateInserted":"2022-07-28T22:51:17+00:00","insertUser":{"userID":115749,"name":"Jason Duryea","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20Duryea","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AFdZucoN485Er-68imH5a6nIxiSUecQ96Py8krC4N2-LQQ=s96-c","dateLastActive":"2022-09-21T11:15:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/337917#Comment_337917","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/337917#Comment_337917

这是有效的，但我忘记添加如果日程变化是空白/空，那么结果应该是灰色的。

我的尝试失败了:

=IF([时间表差异]@row >= 0， "绿色"，IF([时间表差异]@row <= -10， "红色"，"黄色"，IF(ISBLANK([时间表差异]@row， "灰色"))))

杰森的杜 · 07/29/22