Had a little problem recently (10 minuts ago) with key columns.
They ask you for a unique data, but though in one hand โaint nobody dโgot time for filling da key columnโ by themselves, and in the other hand you cannot use a autofill sheet/app formula to do so.
To dodge those annoying restrictions, just opent the column edition menue, chose โauto fillโ and enter your RNG formula in the โinitial valueโ field. Your initial value is now the random/formula generated you wanted, the man finaly beat the machine!
Typically, itโs best to just use UNIQUEID() in the initial formula section for the key column, then do not show it.
I am trying to get this to work for me, but get an error message saying i need to enter my key
Key Columns