Difficulty reading and maintaining complex Excel formulas
π§ workproduct problemSingle report βββββ
The author finds it difficult to track what is happening when Excel formulas become large.
What people do today
- Breaking formulas into multiple cells
- Using named ranges
- Using the formula evaluation tool
π§ Fix this
Ideas a builder, maker or community group could start on:
- A browser-based Excel formula beautifier that converts flat text into a visual, indented tree structure
- A plugin that allows users to write formulas in a multi-line code editor format with syntax highlighting and auto-formatting
- A documentation tool that generates a visual dependency map for complex cell references within a workbook
Real voices
βWhen Excel formulas get large, I often lose track of whatβs actually happening.β
Related problems
π§ workproduct6 reports
LinkedIn login verification loop
π§ workproduct6 reportsInability to filter AI-generated content on LinkedIn
π§ workproduct6 reportsIndeed job feed ignores user preferences
FixHumanityDaily
The most important new problems, and ideas to fix them, in your inbox.
Placeholder: no data is collected yet.