Formulas should be used as columnar operations: you can apply one formula to every element of a column (map) or aggregate an entire column (reduce). (This isn't that much of a restriction - you can use If-Statements to make complex expressions here.)

Spreadsheet browsing is limited to a sample of the data (head + tail); you can set the size of the sample before pulling.