How to display # of request entered by week in Dashboard

Good morning,

We have a form used by our team members to enter any issues they are encountering. I have created another Calculation sheet to create my dashboard based from the sheet collecting the data/form.

I would like to display in my dashboard how many issues are entered every week and show it in a chart by week. What formula should I use in my Calculation sheet? I have attached a screenshot of the columns I have in my data sheet.

Thank you!


  • John_Foster
    John_Foster ✭✭✭✭✭✭

    Hi @Lana Lav,

    I have done a similar thing using two formulas in my secondary calculations sheet.

    The first formula creates the day for the previous Sunday.

    =TODAY() - (WEEKDAY(TODAY()) - 1)

    The second formula is then a COUNTIF formula that does a count on the created date field where it is greater than the value based on the first calculation which is held in a specific field on row 1.

    =COUNTIF({Change Requests Created Dates Range}, > [CalulatedDate]1)

    Hope this helps!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!