Sum if of Current Week +/- 1

Karrie Davis
Karrie Davis Overachievers Alumni
edited 12/09/19 in Formulas and Functions

I have a formula that will give me the current week capacity:

=SUMIF(@{Week Number}, @cell = (WEEKNUMBER(TODAY())), {Capacity}).

 

However I'm not sure of the formula to capacity for the next week or the past week capacity

=SUMIF(@{Week Number}, @cell = (WEEKNUMBER(TODAY()) +7), {Capacity}).

I would greatly appreciate some assistance.

 

Thanks

current.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!