Solved: IFS contain ... row filter by email - Page 2

aminsaleh · 08-28-2023 07:51 PM

Hello there, I hope all is good

I want to do slice row filter condition

I have driver column which is of type ref to workers table.

I also have inspector column which is of type ref to workers table as well.

I have a task column of enumlist value. (contains delivery, inspection .....)

-----

I want to make ifs expression where if task contains for example delivery .. then filter only email of the driver.

I tried this today but did not work

IFS( CONTAINS( [Task] , 'Inspection' ) ,

USEREMAIL()=[worker].[Email]

)

AleksiAlkio

In your case, could it be just as simple as..
IN(
USEREMAIL(),
LIST([Driver].[Email],[Inspector].[Email],[Helper].[Email])
)