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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!