valid_if expression

So i have a form where you can choose between two options "Remove" or "Return"

Another section of the form ask how much?

Is there an expression to use if the choose the option to "Remove" that the value can either be 0 or a negative value and vice verse with Return with positive values?

 

Would this be an OR statement?

Solved Solved
0 7 241
1 ACCEPTED SOLUTION

IFS(
  IN("Return", [Options]), [_This] > 0,
  IN("Remove", [Options]), [_This] <= 0,
  TRUE, TRUE
)

View solution in original post

7 REPLIES 7
Top Labels in this Space