Need total rows by date to compare from 2 separate worksheets.

Jenn F.

I have data from 2 different years, 2023 and 2024, soon to add 2025 :). I am trying to count the total number of rows on each sheet by date they closed, and then do a summary sheet or report to show total number of closures by each date (regardless of year). So as example, in 2023 on 1/10/23 I had four items closed, in 2024 on 1/10 I had 1 item close. I want to ideally do a line graph that shows 1/1 - say 3/1, with the volume that closed each day, one line to show 2023, one line to show 2024. Is there a "simple" way to do this?

Paul Newcome

You would add each month or range of months on each row.

1/1 - 3/31

4/1 - 6/30

so on and so forth.

Then you would use a COUNTIFS. You would have separate years as columns.

=COUNTIFS({Source Sheet Date Column}, OR(IFERROR(MONTH(@cell), 0) = 1, IFERROR(MONTH(@cell), 0) = 1, IFERROR(MONTH(@cell), 0) = 3))

Jenn F.

So I'm confused - by the first part of the solution - "add each month or range of months on each row" - can you give me more substance here? I'm a noob on this part of Smart Sheet sadly :(

Paul Newcome

I believe I misunderstood your original ask. My apologies. You would create a sheet that has each day within the date range listed down a date type column (called "Dates" in this example).

1/1/2025

1/2/2025

1/3/2025

so on and so forth.

Then you would have separate columns for each year and use a formula along the lines of

=COUNTIFS({Source Sheet Date Column}, AND(IFERROR(DAY(@cell), 0) = DAY(Dates@row), IFERROR(MONTH(@cell), 0) = MONTH(Dates@row), IFERROR(YEAR(@cell), 0) = 2025))

You would just need to change that last 2025 to whatever year you need in each of the columns. Then you would graph this table that you have created.