Accessing data in column summary at bottom of sheet

Options

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?

Tags:

Answers

  • Danielle Arteaga
    Danielle Arteaga ✭✭✭✭✭✭
    Options

    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
    Options

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

  • AravindGP
    AravindGP ✭✭✭✭✭✭
    Options

    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)"

    Thanks,

    Aravind GP| Principal Consultant

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

  • Kman1967
    Options

    Thank you all, I have it working...

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!