Advanced Features

Unlock powerful spreadsheet capabilities with special formulas, conditional formatting, dropdowns.

Special Formulas

COL, CELL and Lambdas: The special CELL and COL keyword gets used in lambda functions across the app. For example, =SUMIF(A2:A, CELL > 100) will sum all values in column A that are greater than 100.
GROUPBY: Our take on pivot tables, use a function like =GROUPBY(A1:B, COL[1], SUM(COL[2]) to sum all the values in column B using column A as keys.
MAP: Transform one range into another row-by-row with the MAP function. For example =MAP(A2:B, COL[1] & " " & COL[2]) could be used to concatenate the values in column A and B into a single formula.
FILTER: Filter a range based on a condition. For example =FILTER(A2:B, COL[1] = "Apple") will return all rows where column A is "Apple".
SORT: Sort a range based on a column. For example =SORT(A2:B, 1, -1) will sort the range A2:B by column A in descending order.

Select a range: First select what range the styles will apply to.
Select your styles: Then, choose what styles to apply. Background colors are great for status, strikethrough is handy for task lists.
Write your conditional formula: A conditional formula like =CELL>150 will apply to all cells greater than 50, and =COL[E] = "done" will apply to all cells where Column E for that row is "done".

Dropdowns: Open the dropdown modal from the toolbar to start making dropdowns. Enter in a range to apply the dropdown to, as well as a formula. The formula can be a static array like =["Todo", "In Progress", "Done"] or a dynamic range like =Users!A2:A.
Checkboxes: The special values [ ] and [x] are rendered as checkboxes in a cell, and interpreted as boolean values.
Tags: Use the TAGS formula to turn a table with rows and a header into a compact, single-cell bundle of critical info. When you hover over tags, they show all the data from that row. When combined with other functions like FILTER, tags let your assemble data from many related tables into one master view.