I have the following use case:
- Board with groups
- Each Group has list of items
- List of items with Formula column called as Order
- Column Order uses as Sort column
Would like to have unpredictable / random order for rows in each group.
1 Like
RAND() and RANDBETWEEN(start, end) are available in monday formulas.
RAND() returns a “random” value greater than or equal to 0 and less than 1.
RANDBETWEEN(Lowerbound, Upperbound) returns a “random” integer greater than or equal to {Lowerbound} and less than or equal to {Upperbound}.
The primary issue with both of these functions is that you will need to “trick” them into recalculating for each item or they will return the same value for every item on the board.
One simple way to do this is to use an Item ID column as reference in the functions. Below are examples for each:
RAND({Item ID})
RANDBETWEEN(1, 10 + 0*{Item ID})
Jim - The Monday Man
Column Magic 
- the magical columns toolbox app
1 Like
Thank you very much! It works for me
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.