countif - amount of damages per week / month


I want to show the amount of damages per week / month.

Do you have an idea for a formula ?

I use "Schadeneintritt" (=date of damage) with date as column type

Best Answer


  • Stefan
    Stefan ✭✭✭✭✭✭

    Hi @Jörg Schmidt Novum Hospitality ,

    create a helper column for week and month with the following 2 formulas

    use "WEEKNUMBER"

    and "MONTH"

    and use the values in your COUNTIF with the weeknumber or month from "TODAY".

    Something like

    =COUNTIF(week:week, =WEEKNUMBER(TODAY()))

    Hope this helps


    Smartsheet Consulting, Solution Building, Training and Support.

    Projects for Processes and for People.

  • this shows the amount of damages in the current week.

    Any idea how I can show the number of damages in week1, week2, and so on... ;-)

    Thank you

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!