Fixing exclamation marks in enumlist

[Tech_Service]

I have found a solution for my Valid if with the below code where my Bookings[Rooms] is a list of AllRooms[RoomID]. Although, I got this right how ever, this doesn’t reflect the Ref Collumn for the EnumList therefore it shows the yellow excliamation marks. I now want to remove the excliamation marks.

AllRooms[RoomID] - (SELECT(Bookings[Rooms],AND([_THISROW].[Checkin]<=[Checkin],[_THISROW].[Checkout]>[Checkin]))

please, help!

[Steve]

https://community.appsheet.com/search?q=yellow%20triangle

[Tech_Service · Accepted solution]

I finally fixed this by using Fillter() with IN() function the filter return keys of the room that in the list we want. Therefore

FILTER(“AllRooms”, IN([Key], 
AllRooms[Key]-(SELECT(Bookings[Rooms],AND([_THISROW].[Checkin]<=[Checkin],[_THISROW].[Checkout]>[Checkin])))

[Tech_Service]

Thank you, Steve