If you're manually assigning tasks to a list of names with repeat counts, you're doing work a spreadsheet should handle for you. This Reddit user's request, randomly assign Ann, Mike, and Sam to tasks based on how many times each name should appear, is a common workflow problem that reveals a deeper truth: most people are still building their own inefficient systems inside tools designed to be flexible, not smart.
The user has the right instinct. They want randomness, fairness, and automation. But the way they've framed it, two lists, one with names and repeats, another with tasks, and a desire to "create a spreadsheet where each person name assigned to the task randomly", shows they're thinking in terms of manual construction rather than generative logic. They're picturing a finished table, not a formula that builds itself. That's not their fault. Traditional spreadsheets have trained us to think in cells and static outputs, not in dynamic, repeatable processes.
What this user really needs is an AI-native approach that understands intent. Instead of writing a convoluted formula to expand the name list by repeat counts, then shuffle and pair with tasks, a smarter spreadsheet should let them say: "Assign these people to these tasks randomly, respecting how many times each person should be listed." The tool should handle the expansion, the randomization, and the alignment. The user should only need to define the rules. That shift, from manual construction to intent-based creation, is what transforms a tedious chore into a five-second operation.
This is where the opportunity lies for anyone building or choosing spreadsheet tools today. The old model asks you to be your own programmer, stitching together functions and workarounds. The new model asks you to be a manager: describe what you want, and let the system figure out the mechanics. For this Reddit user, that means no more wrestling with RAND, INDEX, or nested arrays. It means describing the problem once and getting a correct, randomized assignment instantly. That's not a luxury. That's the baseline for a tool that respects your time.