Count If Current Week

2»

Comments

  • I tried that, but since it's with 2 different organizations, it does not allow me to share permissions.

    Could you please help me with the steps, in case if I'm doing something wring

  • I'm the owner of 2 Smartsheet accounts ending with crawco.com & smarter.com. and I'm trying to copy sheets and reports with formulas from crawco.com account to smarter.com

  • Do I have to re-create all the formulas in the new account? :(

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @Sunny Kaul Unfortunately you are going to end up having to recreate everything.

    thinkspi.com

  • brhea110891
    brhea110891 ✭✭✭✭✭

    Going back to the question about getting a count of all entries for this week... I also want to make sure this formula works year to year and that if their are blanks the formula still works. I was trying your SUMIF formula, but I think I am getting my ranges mixed up... I have the helper column "WeekNumber" and the date entry column is "Day 1 Date" This is what I have so far and it is not working... Can you help identify where my error is? Thank you

    This worked: =COUNTIFS(WeekNumber:WeekNumber, =WEEKNUMBER(TODAY()))

    How do I change this into a formula that accounts for blanks and works year to year?I could not get the SUMIF formula to work

    =SUMIF(Day 1 Date:Day 1 Date; AND(IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY());IFERROR(YEAR(TODAY())); _)

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @brhea110891 If I understand you correctly... You want to count how many dates fall within the current week of the current year. If that is the case, you are actually pretty close with your SUMIF formula, but we will want to change it to a COUNTIFS, add the square brackets around the column names, finish out the YEAR portion, and remove that last "range".


    =COUNTIFS([Day 1 Date]:[Day 1 Date]; AND(IFERROR(WEEKNUMBER(@cell); 0) = WEEKNUMBER(TODAY()); IFERROR(YEAR(@cell); 0) = YEAR(TODAY())))

    thinkspi.com