How to get the sum only for a Specific Dropdown Value Selected
Hi,
I want to get the sum for only the dropdown value selected:
Here is the Situation:
First Column: I have 3 Resource Type:
1. Offshore
2. Onshore
3. Remote
Column 2: I have resource Name
Column 03 to 35 is a Hour Cloumn ( Where it shows how mnay hours each of my resource is available to work)
Now I need to calculate:
1. How many totals hours I have for each of my resource (daily, weekly and Monthly)
2. How many total hours I have for each of the resource type mentioned above (daily, weekly and Monthly)
Please help! Please see the attached screenshot
Comments
-
Hello,
The easiest would be to get the totals by:
-adding a Weekly/Monthly Total Hours column to the sheet (can be hidden and used only for calculation purposes)
-using SUMIF function on the Dash part of the sheet to get the total hours by resource
-setting up a report
-
I am going to suggest a few helper rows (3 to 4 of them will work depending on your needs).
You can set them up in any order that is most comfortable for you. The below is simply an example.
Row 1: Day
Row 2: Month
Row 3: Year
Row 4: Week number (1 - 52)
.
These can all be automated or the numbers can be manually added. From there, you will be able to use a SUMIFS statement and pull column totals based on what is in the helper rows depending on what exactly you are looking for.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
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
- 302 Events
- 33 Webinars
- 7.3K Forum Archives