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!
Hi all. I'm trying to do something that I'm not sure if it's possible or not. We have a sheet that we are importing where the first column lists areas within our factory. Each column after that has a column name of a date. So 12/15/2025, 12/16/2025, 12/17/2025, etc. In each of the date columns is a target production…
Hello, I have a checkbox column that I would like to be checked when comparing 2 columns. I would like it to be checked if the 2 columns are not equal or if one of the 2 columns has an error. It's important to note that both columns are numbers. My original formula was: =IF([COLUMN A]@row <> [COLUMN B]@row , 1, 0) However,…
Hello! I have what is probably a simple question my brain is just not comprehending properly. I need to SUMIFS from a sheet that matches some specific criteria but one of the fields I am using against needs to calculate a total if one dropdown field matches ANY ONE of these 3 items that is in it to be chosen… Capitol…
