Combining ISBLANK, IF & AND

Hi All,

I would appreciate your help with trying to set up a formula. I am trying to activate the at risk flag when the 'Date information required' cell is in the past. The side note to this is that I only want it flagged if the 'Date information received' cell is blank and that the flag is not highlighted when all date cells are blank.

I have implemented the formula below which works to a degree. The fault with it is, it is flagging regardless of whether the 'Date information required date' is in the future or past.

=IF(ISBLANK([Date Information Received]@row), NOT(ISBLANK([Date information Required]@row)), [Date information Required]@row < TODAY())

Thanks in advance,

John

Find more posts tagged with

Accepted answers

Maddie Simonsen

Hi John,

This should work:

=IF(ISBLANK([Date Information Required]@row), 0, IF(AND([Date Information Required]@row < TODAY(), ISBLANK([Date Information Received]@row)), 1))

Maddie

All comments

Maddie Simonsen

Hi John,

This should work:

=IF(ISBLANK([Date Information Required]@row), 0, IF(AND([Date Information Required]@row < TODAY(), ISBLANK([Date Information Received]@row)), 1))

Maddie

John Kelly

Thanks Maddie,

That worked perfectly. I was pulling my hair our trying to get it to work.

Thanks,

John

Maddie Simonsen

Happy to help!

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.