Sign in to join the conversation:
Hi,
I can figure out the sumif for the current week but I would like to add another criteria. I keep getting an error could someone help assist
=SUMIFS({Week Number}, @cell = (WEEKNUMBER(TODAY())), {Capacity}, {Work Type}, @cell= "Budget")
Thanks
In a SUMIFs the first reference needs to be what you're trying to "sum"
=SUMIFS([Sum], critera 1, answer, critera 2, answer)
Nick - Smartsheet Product Certified
Thank you Nick,
The first reference is what I'm trying the to sum. The current weeks capacity, but I want to add a second criteria that sum if it is a specific work type. This is where I'm having the problem. Could you please assist.
Thank you
This is the formula I came up with, however I sill can't seem to get it to work.
=SUMIFS({Capacity}, {Week Number}, @cell = (WEEKNUMBER(TODAY())), {Caitlin status}, "In Progress")
Thanks I figured it out
Excellent!
Glad you got it working!
Hello - I am trying to run a basic fomula on my Sheet Summary cell and am absolutly stumped! Are there limitations on how we can use formuals on our Sheet Summary cells? What I want to do add any rows from the weighted ECV column that have 2026 in the Year column. I think this formula should work, correct?…
I'm assuming that the project plan template uses a weighted average to determine % complete on the various sections of the project as well as the project overall. Does anyone know what formula is actually being used?
I need help creating a formula that will calculate my employees time in and out along with their lunch break.
