Spreadsheet users get stuck translating calculations into formulas
Spreadsheet users—especially occasional users—struggle to turn multi-condition calculations and transformations into working formulas, then debug errors or avoid repeating formulas row by row. The evidence includes requests for rolling averages, conditional counts and sums, range matching, and array formulas, often phrased as trial-and-error or help requests. A formula assistant could address this recurring problem, though it would not solve separate spreadsheet frustrations such as cumbersome pivot tables or row limits.
For spreadsheet users who need occasional custom calculations. Mentioned from Oct 2023 to Jul 2026 on Bluesky, Hacker News and Stack Exchange.
26 different people described this problem in 28 separate discussions.
- Indie fit
- 4.0/10
- Pain
- 4.9/10
- Frequency
- 10.0/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 simply do not understand most of the syntax and operations required to make even fairly basic things work. It requires a lot of time and effort for me to get simple things done with a spreadsheet on the rare occasion that I need to manipulate one
Struggling to set OR conditions in my AVERAGEIFS function to read from a particular string the previous strings and their data on a rolling basis. I tried doing it with AVERAGE and FILTER but kept getting an error, so tried again with AVERAGEIFS but no positive results yet
See what to build and who will buy it
- 1 product idea with the smallest useful version and pricing
- 4 places to find your first customers
- 26 more quotes from people who have this problem
- Current workarounds, existing solutions and risks