Not Equal Expression

AppSheet AppSheet Q&A
1

Hi,

I need to add this expression NOT(Approval Lookup[Reporting Manager]=USEREMAIL()) with Select(Approval Lookup[Reporting Manager], AND([_THISROW].[GBU] = [GBU],[_THISROW].[Practice] = [Practice])). I tried once but getting an error.

2

Hi @PreetiKaur

What about this?

SELECT(Approval Lookup[Reporting Manager], 
  AND(
    [_THISROW].[GBU] = [GBU],
    [_THISROW].[Practice] = [Practice]
    USEREMAIL()<>[Reporting Manager]
  )
)
1 Like
3

Hi @Aurelien

This is to get managers list with this condition.

4

Did you try it ? Did you get an error message ? Did you try something else ?

Please provide some informations that allow us to help you.

1 Like
5

Hi Aurelien,

Thankyou, its working now. There was an error coming out because of comma sign was missing from there. Thankyou so much

2 Likes