Flag Item if cell is blank a the date is greater then 3 days

Hi,

Not sure what I am doing, probably something really obvious, but I am trying to flag items that have a cell blank and the date that person was notified is more then 3 days from today. Could someone please assist? I greatly appreciate it!

=IF(AND(ISBLANK([Approver (Type or Email)]@row, [Date Initial Email Sent to Contact]@row >TODAY(+3),1,0)

Find more posts tagged with

Formulas

Accepted answers

L_123

=IF(AND(ISBLANK([Approver (Type or Email)]@row), [Date Initial Email Sent to Contact]@row >TODAY(+3)),1,0)

Missing 2 ending parenthesis, 1 for ISBLANK the other for AND

All comments

L_123

=IF(AND(ISBLANK([Approver (Type or Email)]@row), [Date Initial Email Sent to Contact]@row >TODAY(+3)),1,0)

Missing 2 ending parenthesis, 1 for ISBLANK the other for AND

Katye Reed

You are my hero. Thank you!

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.