Solved: Help with select formula - Page 2

Neal_MF_Harper · 07-31-2019 12:29 PM

So I have this formula that I need a hand with:

ANY(SELECT(Checkout Log[Checked out to], AND([Barcode]=[_THISROW].[Barcode], [Checked Out?]=Yes)))

The above works as expected, however, I would like to setup further so that when “[Checked Out?]=No” it returns static text “EQ ROOM”

Tried playing with IF(), OR() and drinking too much coffee but could not figure out

Thanks in advance my wizard friends!
Neal

LeventK

@Neal_MF_Harper
Try with this:

IF(
	LOOKUP([_THISROW].[Barcode],"Checkout Log","Barcode","Checked Out") = "No",
	"EQ ROOM",
	LOOKUP([_THISROW].[Barcode],"Checkout Log","Barcode","Checked out to")
)

View solution in original post