I need to do a plan for my team. Name, time of working, and I need a formula that can assign randomly in the slot of 1 hour: chat, call break, and task.
You can put all possible entries in a column (say
A) and use a combination of
RANDBETWEEN to select a random entry:
3 are the first and last row of the entry list.
Note that whenever you change a cell,
RANDBETWEEN will generate a new number, which leads to a potential change to all cells. You need to paste values to make them permanent.