BYO Formula Lab: Ask, Build, Solve

How to Create Randomness in Smartsheet

Sarah Stone reached out and was unfortunately not able to share in this meeting. However, we did share a fun conversation about Randomness in Smartsheet.

Because Smartsheet does not have a RANDOM function native to the platform, you have to make one yourself. Sarah used the following function, which uses prime numbers and seems to work well:

=IFERROR(INDEX({Dictionary All Words}, MOD((Today@row -…

see more
View thread 1 comment