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?
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?
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.