How do I calculate hours in a given week for a specific task for a specific person
Hello there
I have a sheet with the following columns:
-[Date] Type: Date
-[Name] Type: Contact List
-[Professional Development Time] Type: Text/Number (# of hours the person spent on professional development)
-[Project Related Time] Type: Text/Number (# of hours the person spent on projects)
Here's a link: https://app.smartsheet.com/b/publish?EQBCT=f31c14236ba746e5afd3319de2f6296c
Now I want to create a chart that calculates per week, the total # of hours, each contact has put towards each of these items.
Here's a visual
I'd imagine it would be using the sumifs formula but I haven't been able to figure out the syntax and how to do it.
Can anyone help?
Thanks in advance,
Sam
Answers
-
Will it be on the same sheet as the data or a different sheet?
-
Preferably on a separate sheet
-
Ok. Using the appropriate steps for creating cross sheet references, it is going to end up looking something like this...
=SUMIFS({Other Sheet Professional Development Time Column}, {Other Sheet Name Column}, "Andrew", {Other Sheet Date Column}, @cell = DATE(yyyy, mm, dd))
You can use cell references to cells on the same sheet as your metrics for the portion that contains "Andrew" and in place of the DATE function. If you choose to use the DATE function, you will need to update the year, month, and day numbers accordingly.
-
Thanks Paul. Am going to be working on this tomorrow. Will let you know how it goes.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!