Expression to filter values based on today's date.

[Dubams]

I want to filter table 1, based on date conditions from table 2.

In other words,  if the end date < today's date and start date is >= today's date, task/room cell should display "not available"

I have tried using filters and other expressions but keep getting, "you cannot compare list with date."

If I were using google sheets, I'd just use an expression like the following, then drag down.

=IF(AND('Room Booking'!F2>today(), 'Room Booking'!E2<=today()), "N/A", "Available").

I want to write an expression on appsheet that would do something similar to the google sheet expression above.

Thank you.