Accessing data in column summary at bottom of sheet

Kman1967

I have a sheet with a Time column tracking hours. I want to filter the rows and then SUM the value of this column (which right now does not sum just the filtered rows). I noticed the SUM of the actual filtered rows displays in a summary pop up at the bottom of the sheet when I select the column. How do I access the data in this popup? If I can't, why hasn't Smartsheet made this available? I have read lots of posts of people asking for this data and Smartsheet has already done the calculation in the background so why not allow access?

Danielle Arteaga

Hi, there. I can't answer your question about why Smartsheet doesn't allow you to edit the automatic SUM at the bottom of the sheet, but you can capture that number in the Sheet Summary (accessed from your right rail menu) by creating a formula that uses your filter conditions.

(You can submit product enhancement requests here: https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409)

For example, let's say you want to know the total hours worked just by full-time employees. You can create a field in your Sheet Summary and use a formula to create the SUM. For example:

=SUMIF([Worker Type]:[Worker Type], "Full-time Employee", Time:Time).

Here's how that might look in context:

You would need to adjust this to your column names, but the basic formula structure is the same. Now, you won't need to filter your rows to get your filtered sums!

Hope this helpful!

Kman1967

Thanks, First part worked. Now how would I do the same thing with "Worker Type" AND Date?

AravindGP

Hi @Kman1967

You can use the SUMIFS formula. =SUMIFS(Time:Time, [Worker Type]:[Worker Type], "Full-time Employee", Datecolumn:Datecolumn, Date(YYYY, MM, DD)), if it is a specific date. If it is any date greater or less than the specified date, just add the appropriate symbol in front of the "Date(YYYY, MM, DD)"

Kman1967

Thank you all, I have it working...