Trying to create a simple IF..OR..ISBLANK formula

I'm getting an invalid operation error and I know I'm making a simple mistake but I've tried everything...

=IF(AND(NOT(ISBLANK([Launch Date/Prod Release/Go Live)]4)), >=TODAY(-7)), 1)

IF the Launch Date/Prod Release/Go Live cell is not blank and the date in the cell is greater than or equal to the date 7 days ago, the Checkbox is True

I want to check the box if the Release Date happened 7 or more days ago..

I'm stuck so any help that can be provided would be appreciated!

Find more posts tagged with

Formulas

Accepted answers

Mathieu PERSICO

Hi sbrelage,

You should repeat the [Launch Date/Prod Release/Go Live)]4 cell to compare it to the date 7 days ago.

Try this:

=IF(AND(NOT(ISBLANK([Launch Date/Prod Release/Go Live]4)), [Launch Date/Prod Release/Go Live]4 >= TODAY(-7)), 1)

Hope this helps,

Sarah Brelage

Yes, that worked! One of my problems was that the column header had an open parenthesis which fueled my confusion. I had tried repeating the column name but had some problems - again I think maybe some confusion around how I named the column. It is working great. Many thanks!

All comments

Mathieu PERSICO

Hi sbrelage,

You should repeat the [Launch Date/Prod Release/Go Live)]4 cell to compare it to the date 7 days ago.

Try this:

=IF(AND(NOT(ISBLANK([Launch Date/Prod Release/Go Live]4)), [Launch Date/Prod Release/Go Live]4 >= TODAY(-7)), 1)

Hope this helps,

Sarah Brelage

Mathieu PERSICO

Nice!

Have a nice day,

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.