How to display # of request entered by week in Dashboard

Lana Lav

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!

Smartsheet columns.JPG

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!

John