How to create totals for different columns for a specific date range

Hi

 

I am struggling to get the total for all the columns in my sheet for each week Monday- Sunday.

My entries are created via webform.

I need to take into consideration the created date for my weekly time range

Could somebody help me please?

Thank you :)

Untitled.png

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Try something along the lines of

     

    =SUMIFS([Column to Sum]:[Column to Sum], Created:Created, WEEKNUMBER(@cell) = xxxxx)

     

    You would just need to update the column names to reflect the correct columns, and enter your criteria in place of "xxxxx" whether it be an actual number (1 - 52) or referencing a cell ([Column Name]@row) or comparing to another date (WEEKNUMBER([Date Column]@row))

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!