Skip to main content

How to make formula where the text value is the condition

  • February 28, 2022
  • 1 reply
  • 0 views

Hello, I’m having troubles figuring away the proper way to make a formula that will:
"if the status = canceled or replaced, the value of the field should be = quantity-quantity (making it a 0) "
where the status is a single select field,
how can I make this work?
Many thanks in advance

1 reply

Forum|alt.badge.img+17
  • Inspiring
  • 77 replies
  • February 28, 2022

Have you tried:

IF(OR({Status}="Canceled", {Status}="Replaced"), ({Quantity}-{Quantity}))

?


Reply