IF OR Formula with ISBLANK

Cheryl Collins

Hi

I'm after a formula that will check if [Date Modified] is more than 30 days from TODAY and / or if the [Current Position] is blank enter boolean to check the box in [Update Required]. This is the formula I have but, it doesn't like it.

What am I doing wrong? Nested formulas are not my strong point!

TIA

Cheryl

Cody Holmes

Hi Cheryl,

It looks like your OR statement is in the wrong place. Try this instead:

IF(OR(ISBLANK([Current Position]@row), [Date Modified]@row>=TODAY(30)), true, false))

Try that out and let me know if that worked. I may have missed a parenthesis or something. But you need to move your OR up to where it's outside both of your testing conditions.

Cody Holmes

Hi Cheryl,

It looks like your OR statement is in the wrong place. Try this instead:

IF(OR(ISBLANK([Current Position]@row), [Date Modified]@row>=TODAY(30)), true, false))

Try that out and let me know if that worked. I may have missed a parenthesis or something. But you need to move your OR up to where it's outside both of your testing conditions.

Cheryl Collins

Hi @cody

There was just an extra closed bracket on the end that needed to come off and it has worked great. Thank you so much 😊