Lookup table check inputs

[kersian]

Hello I have a table "Control de Calidad" with a form that has two inputs ([Control de Adhesivos] and [Control de Calidad]) with options (YES and NO). I want to bring the last Date and Time ([Fecha y hora]) for the last Row that checks if the "Coche" is the same of the form and ([Control de Adhesivos] OR [Control de Calidad]) has the check on YES. I´m trying this formula but is giving me the last ROW and not checking the OR.

Can someone explain me what´s  wrong? 

Thanks and happy holidays to everyone.

LOOKUP(
MAX(
SELECT(
Control de Calidad[_ROWNUMBER],
or(([_THISROW].[Coche] = [Coche]),
([_THISROW].[Control de Adhesivos] = "SI"),
([_THISROW].[Control de Calidad] = "SI"))
)
),
"Control de Calidad",
"_ROWNUMBER",
"Fecha y hora"
)

[dbaum]

AND(
[_THISROW].[Coche] = [Coche]),
OR(
[_THISROW].[Control de Adhesivos] = "SI",
[_THISROW].[Control de Calidad] = "SI"
)
)

[kersian]

Changed for this and now is not bringing me any data: 

LOOKUP(
  MAX(
    SELECT(
      Control de Calidad[_ROWNUMBER],
         AND(
             [_THISROW].[Coche] = [Coche],
                OR(
                   [_THISROW].[Control de Adhesivos] = "SI",
                   [_THISROW].[Control de Calidad] = "SI"
                   )
             )
    )
  ),
  "Control de Calidad",
  "_ROWNUMBER",
  "Fecha y hora"
)

[dbaum]

If you haven't already, confirm whether AppSheet recognizes "SI" as the equivalent of "Y" or "true" for Yes/No type column values. I don't know about that functionality.

[kersian]

I changed to this: 

LOOKUP(
  MAX(
    SELECT(
      Control de Calidad[_ROWNUMBER],
         AND(
             [_THISROW].[Coche] = [Coche],
                OR(
                   [Control de Adhesivos] = TRUE,
                   [Control de Calidad] = TRUE
                   )
             )
    )
  ),
  "Control de Calidad",
  "_ROWNUMBER",
  "Fecha y hora"
)​

and its not working too, maybe the part incorrect is the LOOKUP MAX SELECT?

---