Help with a formula to sum the hours by month by project

Hi all - I need some help building a formula that will show the sum of hours by month (see attached summary sheet - columns Jan 2021 Hours / Feb 2021 Hours) by project. The data that it needs to sum is on the Time Tracking Entry sheet. The unique identifier on both sheets is the "ID". Thanks in advance for any help you can provide.



  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 02/18/21

    Hi @Jen Iliff

    Hope you are fine,please try the following formula

    =SUMIFS({Hours}, {ID}, ID@row, {Today's Date}, MONTH(@cell) = 1)

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!