How can Coda (Business/Productivity Software) improve its formula editor to make complex calculations more intuitive for non-technical users?

Introduction

Improving Coda's formula editor to make complex calculations more intuitive for non-technical users is a critical challenge that could significantly enhance the product's value proposition. As we dive into this problem, we'll explore user needs, pain points, and potential solutions to create a more accessible and powerful tool for our users.

Step 1

Clarifying Questions (5 mins)

• Looking at Coda's positioning as a doc-meets-spreadsheet platform, I'm curious about the current user base composition. Could you share insights on the ratio of technical to non-technical users currently engaging with the formula editor?

Why it matters: This will help us understand the scale of the problem and tailor our solution accordingly. Expected answer: Approximately 70% non-technical, 30% technical users. Impact on approach: A higher percentage of non-technical users would prioritize simplification and guided experiences.

• Considering the evolving no-code movement, I'm wondering about Coda's strategic direction. Is the goal to position the formula editor as a powerful tool for citizen developers, or to make it more accessible to casual users while maintaining advanced capabilities?

Why it matters: This will guide our approach in balancing simplicity with power. Expected answer: We aim to cater to both segments, emphasizing accessibility without sacrificing advanced features. Impact on approach: Would focus on creating layered experiences that grow with the user's expertise.

• Given the complexity of formulas, I'm curious about the current onboarding and education process. What resources or in-product guidance do we currently offer to help users learn and master formula creation?

Why it matters: Identifies gaps in user education that might be contributing to the difficulty. Expected answer: Basic documentation and some tooltips, but limited interactive guidance. Impact on approach: Could suggest incorporating more interactive tutorials or AI-assisted formula building.

• Considering the competitive landscape, how does our formula editor currently compare to alternatives like Airtable or Notion in terms of user satisfaction and feature set?

Why it matters: Helps identify competitive advantages and areas for improvement. Expected answer: More powerful than Notion, but less intuitive than Airtable for beginners. Impact on approach: Would focus on maintaining power while significantly improving intuitiveness.