Isblank difficulty

I'm trying to add an "isblank" to this long formula and keep getting a "syntax" error message. Can anyone help? I want to add - if the "End Date" row is blank then this cell should also be blank. Here's my formula without the Isblank:

=IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), "Red", IF(AND([% Complete]@row < 1, [End Date]@row <= TODAY(7)), "Yellow", IF(AND([% Complete]@row = 1, [End Date]@row >= TODAY()), "Green", IF(AND([% Complete]@row = 1, [End Date]@row < TODAY()), "Gray", ""))))

Find more posts tagged with

Accepted answers

Mike Wilday

Try this...

=IF(ISBLANK([End Date]@row),"", IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), "Red", IF(AND([% Complete]@row < 1, [End Date]@row <= TODAY(7)), "Yellow", IF(AND([% Complete]@row = 1, [End Date]@row >= TODAY()), "Green", IF(AND([% Complete]@row = 1, [End Date]@row < TODAY()), "Gray", "")))))

All comments

Mike Wilday

Try this...

rachelk

Worked perfectly! Thanks Mike!!

Question to help my learning, if you know - I'm fairly certain I added that exact formula at the end and it didn't work. Does the Isblank clause have to go at beginning to work?

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.