Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Feb 27, 2022 09:38 PM
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
Feb 27, 2022 10:47 PM
Have you tried:
IF(OR({Status}="Canceled", {Status}="Replaced"), ({Quantity}-{Quantity}))
?