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 face one difficulty trying to transform text in date using DATE formula I want to find the first day of a week based on the week number & year number put in a cell For instance in a cell I find "25-45" FOR Year= 2025 & Week= 45, so I look for the monday of this week that should be the 3rd of nov Step 1 find first…
I have a formula that I have used for years on a sheet and it was working an hour ago and then all of a sudden it just stopped working, I went out the sheet and back in and . The formula is =IF([Shop Order]@row = 0, (COUNTIF((RN:RN), RN@row ))) but instead of returning the value it says #INVALID COLUMN VALUE Got it working…
Hi Everyone, Looking for some assistance on a dashboard report issue I am running into. I have a dashboard with 3 reports added as Web Content. All 3 reports use at 1 common sheet. All 3 reports are published as read only. Users are not shared the underlying sheets. All 3 reports have some form of filtering. 2 of the…
