Spreadsheet users struggle to express formulas and dynamic references
Spreadsheet users have practical tasks—looking up values, referencing cells in FILTER formulas, keeping column references dynamic, or displaying long identifiers—but can get stuck translating them into the right formula or format. One commenter also describes cumbersome dynamic-column pivot queries in PostgreSQL, an adjacent problem that a broader table-query helper might cover. The evidence for a spreadsheet-focused helper is clearer than the evidence for combining spreadsheet and SQL workflows.
For spreadsheet users maintaining formula-heavy workbooks. Mentioned from Oct 2023 to Apr 2026 on Hacker News and Stack Exchange.
5 different people described this problem in 5 separate discussions.
- Indie fit
- 3.0/10
- Pain
- 4.4/10
- Frequency
- 6.5/10
- Willingness to pay
- 0.0/10
- Momentum
- 5.0/10
- Who pays
- Professionals
- Competition
- High
- Build difficulty
- Medium
What people said
Quoted word for word. Follow a link to read the whole discussion.
I am trying to identify whether the text in a given cell matches onto a list I have made, and then to identify the assigned numerical value from the next cell over
Say the name of the employee (John) is at the top of that person specific sheet (in cell A1), how do I link to that in the FILTER formula?
See what to build and who will buy it
- 1 product idea with the smallest useful version and pricing
- 3 places to find your first customers
- 3 more quotes from people who have this problem
- Current workarounds, existing solutions and risks