Sumifs question

Sumifs forumula question here. For work allocation, each week team members report on the name of their project and the approximate percentage of time it will take. For example, Project A = 50% and Project B = 20%. I'm trying to sum the total of the projects. The first criteria is the status of the project; I want to count only "in progress" precentages. The second criteria is by contact. Since the sheet displays multiple team members, i want a cell to count only the percentages for that team member.

Two questions: first, i have been able to get the formula to work, but i didn't save it properly, and now i can't get back to that original formula. Second, usually when I do this kind of thing, I figure out the formula for the first team member, and then copy and paste the formula for all of the remaining team members, and simply change the contact name. However, on this sheet when i do that, when i make the copy, the original one then shows "unparseable"

Final note* this sheet is for a colleague in London so the word spelling for the word "utilisation" is different than it is spelled in the US. That's not the error.

Best Answers


  • JH@HL
    JH@HL ✭✭

    Hello, Genevieve and Paul - a bit of a belated response, but a huge THANK YOU for the winning suggestions! It totally worked to use the Sheet Summary feature. Now I have a new tool in my toolbox! Your responses were so helpful because they were so quick, solved the problem, and helped me learn something new. All of this is great because I'm trying to get my teams away from Excel and onto Smartsheet. The more I can replicate the familiar format, the more convincing the switch. I've been able to move several, but this particular format was tricky for me. Thanks a million!


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi Julia,

    That's great to hear! Let us know if you have any other formula questions 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!