Could you add RAND() function to Formula column?

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.


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
:magic_wand: Column Magic :sparkles:- the magical columns toolbox app

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.