How do I write the expression to combine the following: I want an action to be available if:
[SSR]>=[PM Task Row Update] And [worktype] is NOT “Preventative Maintenance”
Is then done through the AND function, and if so how do I write it.
OR, is this done through the IFS function?
Thanks, Steven
Your expression would look something like:
AND([worktype] <> “Preventative Maintenance”, [SSR] >= [PM Task Row Update])
thank you jacob, I will try this right now.
yup, that worked!
Thanks.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |