Formula that sums hours where a single value matches a value in a multi select list AND month
I am working on a formula that calculates hours worked where a member exist in a multi-value list and the month.
The detail is recorded in Run Data Sheet. Each record provided the date of the run, start and end time of the run, hours (difference between time in and time out), multi select list of the members that were on the run and then helper column to identify the month and year.
The second sheet is the time reporting for payroll. Columns: Members and then a column for each month. The goal is to pull the hours from the run report to create the payroll report for the month. I have the members listed in the first column but I am struggling to create the formula to sum the hours from the run record for the individual members.
Formula attempted =SUMIFS(RunSheetHours), HAS(RunSheetMember, MemberPayroll sheet), RunSheetMonth, "1").
Any help is appreciated.
Dawn
Answers
-
Hey DMcCallister.
You will have to 1st use a SUM Formula and then have to use a INT Formula to round it back up again. I was struggling with something similar,
This Sheet helped me.
Kind Regards
Brandon
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 352 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!