This should be easy based on the articles out there but I’m running into problems. I’ve purposely added a column in my Google Spreadsheets called RECORDID so I may assign it =UNIQUEID() in the Column editor in the initial value; however, I’m getting all kinds of errors and I can’t figure out why.
The key column ‘RECORDID’ of table ‘ACTIVITY DATA’ is not a legal key because it contains a Formula. - I’ve removed all formulations and the whole column is blank in google sheets. Do you think RECORDID is included in as part of a named range in my google sheets this is causing the error? Could it be if somewhere on my sheet references the RECORDID this would cause the problem? Again, there is no formulation in the column.
This has prompted the editor to choose RowNUM as my default key which I’m trying to avoid.
I just want to move pass this issue :D.