How can I count from the same date, data coming in? (A current week progress)
I'm creating KPI document, where the team enter the weekly update and wants to count the number of support given in one week.
I just want to say if "Week Number" = Same! then Sum "Number of Support"
But I can not get the "SAME" in the IF of SumIF because for not it the symbols are <>, but for being the same?? = =?
I'm thinking of making on Summary Sheet, a each-week sum, but then is hard to make a Dashboard for 52 weeks each year.
Best Answer
-
@Monica Barrera Yes. You would need to use
WEEKNUMBER(@cell) = WEEKNUMBER(TODAY())
as the criteria to get it to compare to today's week number.
Answers
-
Try this:
=IF(WEEKNUMBER([Support Week]@row) <> [Week Number]@row, "True", "False")
-
@Jenn Burk Thanks! because is a good start, but my problem is that Support week and Week number are the same
The Week Number is actually a =WEEKNUMBER([Suport Week]@row
So I get only False.
But is a good start so Im failing on the =IF[WEEKNUMBER(TODAY()) <>[Week Number]@row, "True", "False"
-
@Paul Newcome I saw you help someone on something similar, but I have no idea how to apply it for mine. :) can you help me??
-
You would need something along the lines of
=SUMIFS([Number Of Support]:[Number Of Support], [Week Number]:[Week Number], @cell = 25)
-
@Paul Newcome yeah, but how do I do it to change the sum depending on the current week ? do I have to do 52 fields in the Summary Sheet?
I want to read the count of the WEEKNUMBER.
I want to be able to Sum up all the support for the current week from different people 😁
-
How do I make it say for week 25 (current week) Roberto Ramos had 4 supports
Next week would be week 6 and Roberto Ramos might have 10 supports or 2 , I want a formula that knows what data is happening in the current week
-
somehow this make it work
-
@Monica Barrera Yes. You would need to use
WEEKNUMBER(@cell) = WEEKNUMBER(TODAY())
as the criteria to get it to compare to today's week number.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!