In the following article:
Manually Generating UNIQUEID() Key Values | AppSheet Help Center
The formula for generating unique IDs won't work in Google Sheets or Excel. Please replace the commas "," with semicolons ";".
=DEC2HEX( RANDBETWEEN(0, 4294967295), 8 )
should be:
=DEC2HEX( RANDBETWEEN(0; 4294967295); 8 )
Update: I was advised that this depends on the locale of the sheet. While semicolons are always accepted in formulas, commas are accepted only with US and similar locales. So instead of being a bug report, please treat this as suggestion to add a note about the locale when working with sheet formulas.
Solved! Go to Solution.
I think we discuss this on another post. You should mark this as solved.
The summary: It depends on locale