I'm  having an issue with If/Then logic in a Forms table. In my table, there is a selection box that, based on the selection, should either pre-fill a field or leave it for manual entry. My logic is like =IF("shade specific", pull value from elsewhere, "")

The calculation does work, however, in the manual enter case ("Common"), once I add a new line to the table, the calculation re-evaluates and empties the field. I didn't notice it on this table before last week's Forms Update 2 was applied, but it's all in development right now so may have missed it. And I think I did encounter it on a different form and table previous to the update.

Is there any way to set the Else clause to be whatever was manually entered? I can't use the field's own variable in a calculation, and leaving the final clause empty or "" results in the field getting blanked out after manually entering information.

Thanks.