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

Core App Certified 🦊

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

Connect with me on LinkedIn

Please kindly like ❤️, upvote ⬆️ and/or mark ✅ any of my contributions that have provided value.

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

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

  • SherryFox
    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!

    Sherry Fox

    Business Process Analyst 3 | C5ISR Group | HII | Mission Technologies

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

    Core App Certified 🦊

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

    Connect with me on LinkedIn

    Please kindly like ❤️, upvote ⬆️ and/or mark ✅ any of my contributions that have provided value.

  • Adam Murphy
    Adam Murphy ✭✭✭✭✭✭

    Glad it worked!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!