Is there any workaround that allows a calculation on the field to occur ONLY if there isn’t a value there already? I don’t want automatic calculations overwriting a value that the user has already input. Any solution I try involving other fields is flagged as a circular reference and not allowed.
Hi,
I would suggest create another field, reference the field which is already existed. For example, A1 is the field existed now, create A2, and assign formula like UPDATEIF(A1.RAW="",value_if_true,A1).