Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Sheet Summary
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?
Comments
-
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.
