Sum of hrs utilized per client

Hi Smarties,

I created a time tracker with each column with drop down list for different clients.

1. I want to sum all the hours used per client and to appear in one cell per client, so I can link the cell to auto populate.

I am familiar with step 2( cell linking). Can someone suggest how to run the report on a sheet with many columns with drop down list?

Thanks

Ponni Anand

Find more posts tagged with

Healthcare

Reports

Project Management

Comments

Mike Wilday

I would add a row for each client at the top, and then in the hours column add the following formula:

=SUMIF([Client Column Name]:[Client Column Name], "Client Name", [Hours column name]:[Hours Column Name])

Use that for each client and you will have a nice summary at the top of your sheet.

Aponni

Hi Mike,

Thank you.

The formula that finally worked was very similar to the one you gave but with no" [ ]" for hours column. Don't know why but it worked.

Ponni

Mike Wilday

Glad it worked. You only have to add the brackets if there is a space in the column name. I should have mentioned that.

Aponni

Hi Smarties,

This time around I want to sum Hours spent on a project for month of June. So I am using SUMIFs function. The criterias being choose client "abcd" from client column, hours from hours column and month of June from date column.

=SUMIFS([Client Name:Client Name],"abcd",Hours:Hours,AND(Date:Date),(month@cell=06))

The response is #UNPARSEABLE.

What is wrong with this formula?

Also, any section in the tutorial just for formulas?

Thanks

Ponni

Aponni

Thank You

Mike Wilday

From the looks of your formula, you are trying to use an AND statement when it is unnecessary in the sumifs function. You should the month@cell=06 part is actually at hours:hours: and Date:Date then you should just recreate that after hours:hours and Date:Date. You have some issues with the sumifs formula.

See https://help.smartsheet.com/articles/775363-using-formulas#sumifs for more information on Sum ifs.

I also keep the following bookmarks handy when creating formulas for Smartsheets: