# How can I count from the same date, data coming in? (A current week progress)

Options
edited 06/23/22

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.

• ✭✭✭✭✭✭
Options

@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.

• ✭✭✭
Options

Try this:

=IF(WEEKNUMBER([Support Week]@row) <> [Week Number]@row, "True", "False")

• Options

@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"

• Options

@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??

• ✭✭✭✭✭✭
Options

You would need something along the lines of

=SUMIFS([Number Of Support]:[Number Of Support], [Week Number]:[Week Number], @cell = 25)

• Options

@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 😁

• Options

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

• Options

somehow this make it work

• ✭✭✭✭✭✭
Options

@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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!