Need to give alert in Enumlist

I am having the column with Enumlist with Ref of employee table with key value of Email ID

I should not select my name in that column i need to give some alert as invalid

I tried with Email id <>USEREMAIL in if valid ,but its not working for me

Can you help me with this ?

An Enumlist column will return a List type. So your valid_if probably needs to be something like this:

NOT( IN( USEREMAIL() , [_THIS] ) )

1 Like


I am getting an error with this.

Try:

FILTER( Employee , [Email ID] <> USEREMAIL() )

3 Likes

Thanks,working.