There's a quiet frustration buried in that Reddit post, and it's one we recognize. Someone has already built a workable schedule. They've mapped names to days. They've got the data. What they don't have is a clean way to turn that raw grid into something usable without manual copying, pasting, and sorting by hand. The request is simple: pull the names of people working a given day into a separate list, alphabetized, with no blank rows, and have it update automatically when the day changes. That's it. And yet, the formula they tried only works for one column. The moment they need it to respond to the day of the week, the logic breaks.
This is where most spreadsheet users hit a wall. They know the tools exist. They can feel that the answer is close. But the gap between "I can see the data" and "the data presents itself the way I need it to" is exactly where productivity goes to die. The good news is that the solution isn't exotic. It doesn't require a new app or a course in database design. It requires a shift in thinking: from treating the spreadsheet as a static grid to treating it as a system that can filter, sort, and reformat itself based on conditions. The person who posted this isn't asking for magic. They're asking for the next logical step in their own workflow, and the fact that they're reaching for SORT and FILTER shows they're already on the right track.
What they need is a formula that references the day of the week as a condition, then pulls from the correct column, filters out blanks, sorts the results, and stacks them cleanly. That's not a niche ask. That's the difference between a roster you have to babysit and a roster that's ready when you are. The request also reveals something important about how people actually want to use spreadsheets: they want the tool to do the thinking, not just the storing. They don't want to see every name and every shift. They want to see the answer to a specific question, like "who's here on Wednesday?" and they want that answer to be neat, alphabetical, and complete.
The fact that this person is asking for help in a public forum, with screenshots and a clear example, shows they're not looking for a handout. They're looking for a method. And that's the mindset we'd encourage everyone to adopt. Stop settling for a schedule that requires manual effort to read. Build the logic once, and let it do the heavy lifting from there. If you're stuck on a formula that only works for one column, step back and ask what condition changes the output. The answer is usually a single reference to a cell that contains today's date or a day name. Add that, wrap it in FILTER and SORT, and you're done. The roster builds itself. That's not just convenient. That's the point of using a tool like this in the first place.