CONTAINS([RAMPA],LOOKUP(USEREMAIL(),RAMPE,EMA...

[francesco_canno]

CONTAINS([RAMPA],LOOKUP(USEREMAIL(),RAMPE,EMAIL,UTENTI))

hi I use this formula as a security filter in a table called CENTRAGGIO what I would like to do is that when a data is inserted in the SBLOCK column The user no longer has access to the data. can you implement the formula?

[Sdfaheemuddin]

Use AND link AND(CONTAINS (…),NOT(CONTAINS(…)))

[francesco_canno]

I did not specify that the data that I insert in the SBLOCK column is time value therefore always different. I would like the formula to work when the SBLOCk column is populated

[Sdfaheemuddin]

Then

AND(CONTAINS([RAMPA],LOOKUP(USEREMAIL(),RAMPE,EMAIL,UTENTI)), ISBLANK([SBLOCK]))

[Yilmaz_Kandis]

Try combining your formula with NOT(ISBLANK([SBLOCK]))

[francesco_canno]

@Sdfaheemuddin

thank you it works perfectly