That formula is a valiant attempt, but it's fighting the wrong battle. You're not doing anything fundamentally crazy, you're just asking `FILTER` to do something it wasn't designed to do. `FILTER` returns entire rows or ranges from an array based on a condition. Pasting `H1+J1+K1+N1+O1` into the first argument creates a single value (the sum of those cells), not a row of data. And `P:P="Yes"` is checking every row in column P, not just row 1. The result is either a single number or an error, depending on whether any cell in column P says "Yes." That's not moving data; that's mashing it together.
What you actually want is a conditional transfer, not a filter. For a single row, the simplest path is an `IF` statement. In Sheet2, write `=IF(Sheet1!P1="Yes", Sheet1!H1, "")` in the cell where you want column H's data. Repeat that pattern for columns J, K, N, and O. It's not elegant, but it's honest. When `P1` says "Yes," each formula pulls its respective cell. When it says anything else, the cell stays blank. That's the whole trick. No arrays, no sums, no confusion.
This is the kind of moment where legacy spreadsheet tools reveal their friction. You found a reasonable formula online, adapted it to your use case, and it failed because the tool's logic is rigid. The barrier isn't your understanding, it's that traditional spreadsheets force you to translate human intent into brittle, single-purpose syntax. Every new condition, every extra sheet, every dropdown adds another layer of mental overhead. That's not how work should feel. You should be able to say "when this dropdown says Yes, move those cells over there" and have the tool understand you.
The good news is that this friction is solvable. AI-native spreadsheets don't make you guess through formula errors. They interpret your intent, handle the mapping, and automate the transfer without you needing to debug a `FILTER` expression. For now, the `IF` approach works. But the real takeaway is this: if you're spending more time fighting formulas than analyzing data, it's a sign that the tool is holding you back. The solution isn't a better formula, it's a better tool.