The new field on the spreadsheet reflects the inserted formula and not the
resulting value. During the insert process however, the expected output
appears properly in the Function Arguments window.