Formula

Hello,

I need to show [Supervisor] column if [Position] column prior is NOT "Supervisor" or "Manager". I could not use <> then specify these 2 words. I temporarily settled to just using = and specifying all the other values cause I have a few. This isn't wise. Can somebody tell me what formula to use? Thank you!

Solved Solved
0 2 50
1 ACCEPTED SOLUTION

In the [Supervisor] column show_if please try something like 

NOT( OR([Position] ="Supervisor", [Position]="Manager"))

View solution in original post

2 REPLIES 2

In the [Supervisor] column show_if please try something like 

NOT( OR([Position] ="Supervisor", [Position]="Manager"))

Perfect! Thanks a lot Sir!

Top Labels in this Space