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.
OR(IN([Update Type],{New Personnel,Sale}),[Standard Set]=โYesโ)
Thank you!
User | Count |
---|---|
36 | |
33 | |
28 | |
23 | |
18 |