IF Statement Returning #UNPARSEABLE

Bethany Garcia

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”)

Bassam Khalil

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:

Bassam Khalil

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:

Bethany Garcia

That worked, thank you!

Bassam Khalil

@Bethany Garcia 

Excellent, i will be happy to help you any time.