I have a sheet that I created as a log essentially. What I'm wanting to do is create a "report" that summarizes the data. As an example, I want to report total records, smallest number, largest number, and count of records with a specific condition. How would I go about doing this?


Currently, your best bet would be to add a summary section with data at the top of your sheet. There is no current way to write formulas on data from other sheets. 

If you add a column to your sheet, you would be able to add something unique to your summary rows and then feed them into a report that is pulling from that sheet and only shows items with the value unique to your summary row. That would keep your summary data in a separate report, but it would exist on your sheet at the top.