Skip to main content

Shuffle items within cell

  • March 9, 2021
  • 1 reply
  • 11 views

Hi All, we use Airtable to manage our social media and one cell has a list of hashtags (one on each line) and we’d like to figure out a formula to shuffle the lines so the hashtags don’t post in the same order every time.

Any ideas?

1 reply

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • 6009 replies
  • March 9, 2021

Do you want a script or a formula?

A script can randomize a list because JavaScript has a random function.

A formula does not have a random function, but you can have a formula rearrange items in a string based on a value that is slightly different from record to record—such as the second of the created time of the record.