Help with revision of Nest IF Statement for Symbols

SherryFox

Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay,

@dojones  provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was:

=IF(AND(ISBLANK(Certify@row), ISBLANK([User Name]@row), ISBLANK(Group@row)), "Red", IF(AND(Certify@row = "Revoke", OR(ISBLANK(Comments@row), ISBLANK([User Name]@row), ISBLANK(Group@row))), "Yellow", IF(OR(ISBLANK(Certify@row), ISBLANK([User Name]@row), ISBLANK(Group@row)), "Yellow", "Green")))

Now the new criteria is that the User Name will be a field that WE complete before it is sent to be reviewed. So based on that, the User Name field no longer matters.

Adam Murphy

Something like this? =IF(AND(ISBLANK(Certify@row), ISBLANK(Group@row)), "Red", IF(AND(Certify@row = "Revoke", OR(ISBLANK(Comments@row), ISBLANK(Group@row))), "Yellow", IF(OR(ISBLANK(Certify@row), ISBLANK(Group@row)), "Yellow", "Green")))

Adam Murphy

Something like this? =IF(AND(ISBLANK(Certify@row), ISBLANK(Group@row)), "Red", IF(AND(Certify@row = "Revoke", OR(ISBLANK(Comments@row), ISBLANK(Group@row))), "Yellow", IF(OR(ISBLANK(Certify@row), ISBLANK(Group@row)), "Yellow", "Green")))

SherryFox

@Adam Murphy ,

That worked perfectly, thanks! I attempted to remove all instances of the User Name field, however I just got errors. Thanks for the assist!