Help with revision of Nest IF Statement for Symbols

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.

Sherry Fox

Business Process Analyst 3 | C5ISR Group

HII | Mission Technologies

EAP | Mobilizer | Automagician | Superstar | Community Champion Class of 2024

NEW (Work) Profile: @SherryFox | OLD (Personal) Profile: @Sherry Fox

Connect with me on LinkedIn

Tags:

Best Answer

  • Adam Murphy
    Adam Murphy ✭✭✭✭✭✭
    Answer ✓

    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")))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!