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.

It is a team of 15 people, I can't find any formula for this. enter image description here

  • Welcome to Web Applications. Please show what you tried and add more descriptive information about your search efforts as is suggested in How to Ask.
    – Rubén
    Apr 12 at 15:12

You can put all possible entries in a column (say A) and use a combination of INDEX and RANDBETWEEN to select a random entry:


Here 1 and 3 are the first and last row of the entry list.

enter image description here

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.

  • thank you, nice this formula you advised me, now it is possible to add a rule, so that an agent per day has 1 break, 2 chats and 2 calls, and the rest task so that in a group of 15 people for the same time there is coverage with 2 chats and 2 calls, I don't know if I made myself clear, I also attached the screen with the color reference.
    – flora
    Apr 12 at 18:07
  • That makes it a lot more complicated, I'll have a look but I don't want this to turn into a chameleon question.
    – Glorfindel
    Apr 13 at 16:03
  • omg, I hope not, anyway thanks for the help!
    – flora
    Apr 14 at 16:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.