Lists subtraction

[SviluppoHW]

Hello,

I need your help for a substraction of lists.

I have the first table with the list of the rooms (1, 2, 3, 4, 5, 6).

Then I have the second table with the bookings of these rooms.

I have to make an expression subtracting the rooms already booked from the first list

adding the condition about the dates (check-in and check-out) inputed in the second list and that the user is adding in the form .

Thanks

[Lynn]

Hi @SviluppoHW

Have you checked out the documentation on Lists

https://support.google.com/appsheet/answer/10107669

[SviluppoHW]

For sure, but I didn’t come up with it…

This is my expression:

Select(Rooms[IDRoom], true)

Select(Bookings[IDRoom],
AND(Bookings[IDRoom]=[_THISROW].[IDRoom],
[_THISROW].[EndDate] > [StartDate],
[_THISROW].[StartDate] < [EndDate])
)

[Steve]

Remove the table reference as shown below: