Accessing data in column summary at bottom of sheet
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?
Answers
-
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!
-
Thanks, First part worked. Now how would I do the same thing with "Worker Type" AND Date?
-
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
-
Thank you all, I have it working...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!