selectRandomCell
Selects a random cell from the given array (list) of cells.
This function accepts rows, columns and a combination of both as shown in the video
This function spends 0 credits per execution
- cells: The cells from the ones you want to select one randomly
- String: A random cell from the given list
selectRandomCell(A1:A7)
// 1,2,3,4,5,6,7
// Returns --> 4
- Use Google Sheets to improve your anchor text variety
- Use Spreadsheets to select one winner from a list of users
Last modified 4mo ago