IF OR Formula with ISBLANK

Options

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

Best Answer

  • Cody Holmes
    Cody Holmes ✭✭✭✭
    Answer ✓
    Options

    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.

Answers

  • Cody Holmes
    Cody Holmes ✭✭✭✭
    Answer ✓
    Options

    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
    Cheryl Collins ✭✭✭✭✭✭
    Options

    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 😊

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!