I need to write a formula which updates a calculated value if there is a value in a form field, but doesn't update the calculated value if the form field is empty.
I've been trying to use the “If” Runtime Function, and in the formula builder the syntax is reported as:
If(logical_test, value_if_true, value_if false)
How do I say, for value_if_false, do nothing? If I use quotes for value_if_false, this overwrites the value in the calculated value with a null value.
Or is there another way to say, for a calculated value formula, if there's a value in the form field, write that value to the calculated value, else do nothing?
