Filtering with specific email

PHOTO

Sat Nov 02 2024 15:03:33 GMT+0000 (Coordinated Universal Time)

AND(
    OR(
        ISBLANK(ANY(SELECT(Filters Slice[Staff], USEREMAIL()=[Email]))),
        ANY(SELECT(Filters Slice[Staff], USEREMAIL()=[Email])) = [Staff]
    ),
    OR(
        ISBLANK(ANY(SELECT(Filters Slice[From...], USEREMAIL()=[Email]))),
        [Date] >= ANY(SELECT(Filters Slice[From...], USEREMAIL()=[Email]))
    ),
    OR(
        ISBLANK(ANY(SELECT(Filters Slice[To...], USEREMAIL()=[Email]))),
        [Date] <= ANY(SELECT(Filters Slice[To...], USEREMAIL()=[Email]))
    )
)

COPY