Counting weekly entries from a Created By field

Options

I am looking to count all the entries from a Created By field in Sheet 1 and deposit that count into a Sheet 2 that contains rows for each week of the year 1-53. The intended use is to show week over week counts of inquiries. Will eventually want to specify the count per support type for each column on Sheet 2 (Sales, Training, etc), but will have to walk before we can run, so any help would be appreciated).

Sheet 1:

Sheet 2:


I have tried:

=COUNTIF(WEEKNUMBER({Created Date}), WEEKNUMBER([Week Number]@row))

and several variations with no success.

Answers

  • isa.ohara
    isa.ohara ✭✭✭✭
    Options

    I believe what needs to be done is to add a helper column to your sheet that stores the WeekNumber - it can't pull the WeekNumber from the Range - and then get rid of the "WEEKNUMBER" for the WeekNumber@row


    So it would be: =COUNTIF({WeekNumberColumn}, @cell = [Week Number]@row)

    I was trying it out and had the same problem

  • crodts
    crodts ✭✭
    Options

    Is there a way to do this without adding a helper column to Sheet 1? The rows in this sheet copy to many more sheets and I would like to avoid having a Week Number column copied over to the other sheets each time.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!