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.

Find more posts tagged with

Formulas

Accepted answers

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

All comments

Adam Murphy

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!

Adam Murphy

Glad it worked!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.