NOT IN Expression

AppSheet AppSheet Q&A
1

or([EstimatorCode]<>“Kevin”,[EstimatorCode]<>“Ian”,[EstimatorCode]<>“Phil”,[EstimatorCode]<>“Diane”,[EstimatorCode]<>“Jack”,[EstimatorCode]<>“Sarah”)

In a slice, I want to exclude people from the data return as above, however each result is true and the result is that everybody is returned. Any help to exclude these people would be great.

Many Thanks

2

AND([EstimatorCode]<>“Kevin”,[EstimatorCode]<>“Ian”,[EstimatorCode]<>“Phil”,[EstimatorCode]<>“Diane”,[EstimatorCode]<>“Jack”,[EstimatorCode]<>“Sarah”)

Alternatively you could also try,

NOT (IN ([EstimatorCode], LIST(“Kevin” , “Ian” , “Phil” , “Diane” “Jack” , “Sarah”)))

3

NOT (IN ([EstimatorCode], LIST(“Kevin” , “Ian” , “Phil” , “Diane” “Jack” , “Sarah”)))

Works great @Suvrutt_Gurjar . Thank You

1 Like