Hi I am trying to set up a conditional formula where if the value of [column] is “this” then [column] * (-1) i just want to get the negative value of the ref column when certain condition is met but I can not figure out how the formula should be.
If you’re trying to modify an existing value in [column], with the old value as an input, then you’ll probably need to do so with an Action.
When is this calculation supposed to happen? Is it after a record is input via a Form view? If so, then I’d suggest running the Action as that Form’s Form Saved Behavior.
i figured it out, thanks for the answer