IF Statement Returning #UNPARSEABLE

I am trying to get this formula to work to return Active if the field Work End Date is either blank or is greater than/equal to today, or return Inactive if neither of those statements are true. I'm receiving an #UNPARSEABLE error though and can't figure out why it isn't working.

=IF(OR(ISBLANK([Work End Date]@row), [Work End Date]@row >=TODAY()), "Active", “Inactive”)

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 08/23/21 Answer ✓

    Hi @Bethany Garcia 

    Hope you are fine, please try the following formula :

    =IF(OR([Work End Date]@row >= TODAY(), ISBLANK([Work End Date]@row)), "Active", "Inactive")

    the following screenshot shows the result:

    PMP Certified


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"