I have a field that auto-populates via a trigger formula, but that will often be “over-written” manually. I’m hoping to find a way to kind of “lock” records upon a certain condition such that their trigger formulas don’t trigger, and the manually-entered values aren’t erased.
This is where my brain first went and kind of explains what I want to happen:
if condition: return $SomeOtherField else: return $ThisField
But then I end up with circular logic since it doesn’t work the same as a transform.
To sum up, if the condition is not met, I don’t want the value to change/update from whatever was manually entered into the cell.