Sum Duration by Weeknumber


I have the following columns that pertain to my formula:

Week Target - has a number (no formula that represents the target week of the year)

Duration (minutes) - this has how many minutes each task will take.

I want to create 3 sheet summary formulas that show a total of the hours of tasks set for for Last week, this week and next week.

For the current week, I've tried the following: =SUMIFS(WEEKNUMBER([Week Target]:[Week Target])@row = WEEKNUMBER(TODAY()), [Duration (minutes)]:[Duration (minutes)]) / 60)

What is wrong in this formula or is there a better way to do this?

Where do I add the -1 for last week's formula?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!