How do I write the expression to combine the ...

expressions
(Steven Jeffery) #1

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

(Jacob Lin [AppSheet]) #2

Your expression would look something like:

AND([worktype] <> “Preventative Maintenance”, [SSR] >= [PM Task Row Update])

(Steven Jeffery) #3

thank you jacob, I will try this right now.

(Steven Jeffery) #4

yup, that worked!

Thanks.