How can I total actual hours complete by who it is assigned to?
I currently am able to calculate the total hours assigned to each person, but I would like to show how many hours are complete and that still need to be completed for each individual. This is the formula I am using to calculate total hours assigned and this is working. =SUMIF({Assigned To 3}, Primary24, {Estimated Hours 3}) + SUMIF({Assigned To 4}, Primary24, {Estimated Hours 4}) + SUMIF({Assigned To 5}, Primary24, {Estimated Hours 5}) + SUMIF({Assigned To}, Primary24, {Estimated Hours}). Now I want to add the aspect of if the status is complete. Please let me know if you have any ideas!
Best Answer
-
Hi @EJ End
I would change each group of SUMIF to SUMIFS, adding status condition and moving the {Estimated Hours #} range in front.
For example;
SUMIFS({Estimated Hours 3}, {Assigned To 3}, Primary24, {Status},"complete")
Or I would use COLLECT to create a range with the status condition to be used in the SUM function.
For example;
SUM(COLLECT{Estimated Hours 3}, {Assigned To 3}, Primary24, {Status},"complete"))
Answers
-
-
Hi @EJ End
I would change each group of SUMIF to SUMIFS, adding status condition and moving the {Estimated Hours #} range in front.
For example;
SUMIFS({Estimated Hours 3}, {Assigned To 3}, Primary24, {Status},"complete")
Or I would use COLLECT to create a range with the status condition to be used in the SUM function.
For example;
SUM(COLLECT{Estimated Hours 3}, {Assigned To 3}, Primary24, {Status},"complete"))
-
That worked!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 209 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 298 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!