USing IF and ISBLANK with two columns

Please help. I posted this almost two months ago and still have gotten no help. I am currently using AT-RISK indicators for certain tasks that have not been closed.

The first formula works but does not turn off on the indicator once the task is closed.

=IF([Committed Closure Date]@row - TODAY() > 10, "Green", IF(AND([Committed Closure Date]@row - TODAY() >= 6, [Committed Closure Date]@row - TODAY() <= 10), "Yellow", IF([Committed Closure Date]@row - TODAY() <= 5, "Red")))

I am trying to create another formula that will not show the indicators once the Closure Date column contains a date and no longer blank. This is what I have so far which has not worked for me. Please help.

=IF(AND(ISBLANK([Closure Date]@row), [Committed Closure Date]@row - TODAY() > 10, "Green", IF(AND(AND(ISBLANK([Closure Date]@row), [Committed Closure Date]@row - TODAY() >= 6, [Committed Closure Date]@row - TODAY() <= 10), "Yellow", IF(AND(ISBLANK([Closure Date]@row), [Committed Closure Date]@row - TODAY() <= 5, "Red"))))))

Find more posts tagged with

Conditional Formatting

Accepted answers

Razetto

What about something like this?

=IF(NOT(ISBLANK([Closure Date]@row)), " ", IF([Committed Closure Date]@row - TODAY() > 10, "Green", IF(AND([Committed Closure Date]@row - TODAY() >= 6, [Committed Closure Date]@row - TODAY() <= 10), "Yellow", IF([Committed Closure Date]@row - TODAY() <= 5, "Red"))))

Razetto

Glad it worked out!

All comments

Dami

Razetto

What about something like this?

Dami

@Razetto Well that works! I've been suffering for weeks. Thank you so much!

Razetto

Glad it worked out!

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.