Update to Is Not Blank Formula?

How do I make this formula operate the way I need to. If there isn't a due date or a status, I don't want it to get flagged as at risk yet.

=IF(OR(Status@row = "Completed", [Due Date]@row = " "), 0, IF(AND(Status@row <> "Completed", [Due Date]@row - TODAY() <= 3, [Due Date]@row - TODAY() >= 0), 1, 0))

Find more posts tagged with

isnotblank formula

Accepted answers

All comments

brianschmidt

You could try something like this at the start of your nested if formula:

=IF(AND(NOT(ISBLANK([Due Date]@row)), (NOT(ISBLANK(Status@row))), 0, IF(…

Having this at the start, it will ensure that items that do not have a status and also do not have a due date are not flagged.

Your completed formula would look like this adding on what you already had:

=IF(AND(NOT(ISBLANK([Due Date]@row)), (NOT(ISBLANK(Status@row))), 0, IF(OR(Status@row = "Completed", [Due Date]@row = " "), 0, IF(AND(Status@row <> "Completed", [Due Date]@row - TODAY() <= 3, [Due Date]@row - TODAY() >= 0), 1, 0)))

Is this what you were looking for?

Jeannie_Biles

I remember now why I had abondoned this effort. The cell is not considered blank if there is a formula in it.

brianschmidt

@Jeannie_Biles I'm not sure which fields you have formulas in, but you can also use different qualifiers instead of the isblank function, such as a ISDATE() function for the due date (assuming you have this column formatted for dates) and you could use a OR(NOT(), NOT()), etc. type function for the status field to rule out all possible statuses (assuming there is a limited list of dropdown or possible outcomes for this field).

Hope this helps!

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.