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

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


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



  • Viktoria B.


    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.