# Sum if of Current Week +/- 1

Options
Overachievers Alumni
edited 12/09/19

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

• ✭✭✭✭✭✭
Options

Hi Karrie,

Try this.

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

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

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Overachievers Alumni
Options

Thank you another quick question, I want to add another criteria.

=SUMIFS({Week Number}, @cell = (WEEKNUMBER(TODAY())), {Capacity}, {Work Type}, @cell= "Budget")

Thanks

• ✭✭✭✭✭✭
Options

Happy to help!

Your correct that you'll need to use a SUMIFS formula but that formula is structured differently.

Hope that helps!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Overachievers Alumni
Options

I thought i  wrote the formula correctly but I still can't get it to work. I want the sum of capacity if it is the current week and work status is in progress.

=SUMIFS({Capacity}, {Week Number}, @cell = (WEEKNUMBER(TODAY())), {Caitlin status}, "In Progress")

• Overachievers Alumni
Options

Thanks I figured it out

• ✭✭✭✭✭✭
Options

Glad to hear that you solved it!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!