Shuffle items within cell

[FZK_Team]

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?

[kuovonne]

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.