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

Credits cost per execution

This function spends 0 credits per execution

Video example


  • cells: The cells from the ones you want to select one randomly

Expected output

  • String: A random cell from the given list

Text example

// 1,2,3,4,5,6,7
// Returns --> 4

Use cases

  • Use Google Sheets to improve your anchor text variety

  • Use Spreadsheets to select one winner from a list of users

Last updated