Strange behaviour of script generated formula column; no data until I copy+paste the column in the same datatable
I have a script that loads data from excel and then generates a new formula column. The column appears empty however, even though my formula preview shows values. Once I copy/paste the column into the same datatable suddenly the values appear. What's going on here? Easiest demo is through the gif below. I also added the script and excel sheet.Names Default To Here( 1 );
//Prompt to select and ope
...