Formula to show number of requests entered each week

Paul Newcome

@Eric Isaacs Yes. What are your column names?

Eric Isaacs

@Paul Newcome i believe my main column would be "Internal Status" and the date created would be my Smartsheet system date i call System Created Date . Those are the column names I've tried in the formula below

=COUNTIFS([Main Column]:[Main Column],NOT(ISBLANK(@cell)),[Date created]:[Date created], WEEKNUMBER(@cell)=WEEKNUMBER(TODAY()))

Paul Newcome

@Eric Isaacs Ok. And is that causing an issue?

Eric Isaacs

@Paul Newcome yes - it's giving me the Unparseable error.

MichaelTCA

@Eric Isaacs

When using the WEEKNUMBER formula, are you referencing a column that has Date properties?

It's possible that the formulas are not being used with the correct column properties.

Eric Isaacs

@MichaelTCA Hi Michael - in my formula:

=COUNTIFS([Main Column]:[Main Column],NOT(ISBLANK(@cell)),[Date created]:[Date created], WEEKNUMBER(@cell)=WEEKNUMBER(TODAY()))

Should I change it to

=COUNTIFS([Main Column]:[Main Column],NOT(ISBLANK(@cell)),[Date created]:[Date created], WEEKNUMBER({Date Opened]@cell)=WEEKNUMBER(TODAY()))

The [date Created] reference in the formula above are to the Smartsheet date

MichaelTCA

@Eric Isaacs

Try

=COUNTIFS([Main Column]:[Main Column],NOT(ISBLANK(@cell)),[Date created]:[Date created], WEEKNUMBER([Date created]@row)=WEEKNUMBER(TODAY()))

Or if the values in the date created column are 1-52, then

=COUNTIFS([Main Column]:[Main Column],NOT(ISBLANK(@cell)),[Date created]:[Date created], @cell=WEEKNUMBER(TODAY()))

Paul Newcome

@Eric Isaacs Can you provide a screenshot of the sheet including the column names?

Is the formula in the same sheet as the data you are referencing or a different sheet?

@MichaelTCA We still want to continue using the @cell inside of the WEEKNUMBER function.

Eric Isaacs

@Paul Newcome @MichaelTCA With your help I might have been able to figure this out. I'll have to test it out next week when my week changes. Thanks so much for both of your help!

Eric Isaacs

@MichaelTCA @Paul Newcome thank you both - I was able t get this figured out - thanks again!

Paul Newcome

Happy to help. 👍️