If Or function including date

Jamie Teut

HI Team,

I am trying to return Active or Inactive based on two criteria one being today's date being < the end date and the other based on a check box. I can mix it up and get the formula to work for either the date or the tick box but not for both.

=IF(OR([Formula check box]@row = 0, TODAY() < [TBA actual end date]@row), "Active", "Inactive")

Both of these photos should be returning an Inactive result. Where am I going wrong??

AravindGP

Hi @Jamie Teut

If you're looking for both conditions being met, the formula should be

=IF(AND([Formula check box]@row = 0, TODAY() < [TBA actual end date]@row), "Active", "Inactive")

Jamie Teut

I'm looking to show an inactive result when the end date is in the past OR if it is not expired and the 'Formula check box' is ticked I need to show an inactive result too

AravindGP

Hi @Jamie Teut

Please share the names of the columns as in your sheet that you want to check and the logic. Trying to figure out what constitutes as not expired.