Learn how to sort your data in a Google Sheet in randomized order using Excel formulas and Google Apps Script.
Nice little snippet from Amit Agarwal which includes some Google Apps Script code for randomising the order of rows in Google Sheets. The code has some clever use of .autoFillToNeighbor()
, .offset()
and .sort()
.
Source: Sort by Random – How to Randomize the Order of Rows in Google Sheets – Digital Inspiration
Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.