Hello, this has got to be a simple question b...

expressions
(Jenn M.) #1

Hello, this has got to be a simple question but hard to find the answer.

I’m trying to write a column restraint expression. I’d like the column to show if another column has a value of either “New Personnel” or “Sale”.

My code for the “Show_If” constraint is as follows:

[Update Type] = “New Personnel” .

My question is, how do I include “Sale” in the expression so that the column also shows if the “Update Type” column has a value of either “Sale” or “New Personnel” ?

Furthermore, I need this same column to show if the “Standard Set” column (same table) has a value of “Yes”.

How to incorporate all this in one expression?

Thanks for any thoughts.

(Aleksi Alkio) #2

OR(IN([Update Type],{New Personnel,Sale}),[Standard Set]=“Yes”)

(Jenn M.) #3

Thank you!