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 |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |