How to get the sum only for a Specific Dropdown Value Selected

Rafsun Royal
Rafsun Royal ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com