Tables, not spreadsheets
Real applications need real tables.
Head of Strategy & Insights at Coda
Some simple spreadsheet formulas using R1C1 notation
- Where do formulas live? Do formulas live in cells like they do in a spreadsheet, or are they defined at the column or row level? Would we support formulas on the canvas?
- What is the reference model? Do formulas use an object name (e.g. the name of a table or column) or refer to a location (e.g. the position of a cell ー is it geometric)? Is there a workable hybrid where you point to a location, but pretty print with the names of the object in that spot (a la Apple’s Numbers)?
The original sketch of the options for formulas in tables vs spreadsheets
A simple table with a chart view and a calendar view
A canvas formula that counts the number of open tasks in the table
Column types enable our formula autocomplete to make type specific recommendations
The way a projection is done in a spreadsheet using a VLookup
The way a projection is done in Coda, using a Lookup column
Getting a cell value in Coda through the @ref