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

Sarah Brelage

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!

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!

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!

Mathieu PERSICO

Nice!

Have a nice day,