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 could use some help with this one. I got the formula to work in the "number column"…. but I cant currently get it to work as a column formula. Basically what I am trying to achieve is have it add a number in order if the "footer comp" column is unchecked. and miss is unchecked Right now it is counting but in the…
I'm need to apply a function to average a column (answer is correct (8)) if the other column (The nurse is caring for a a patient who dove into a) is NOT blank. I copied this over from an excel spreadsheet. I would like to keep the average in the top row. Right now it's saying "#unparseable" as the formula is not the same…
This discussion was created from comments split from: How do I combine multiple INDEX Collect formulas in one Formular?.
