Count instances in a sheet and plot them against year entered

Hello! Each row in my sheet is a research case. I would like to count each row and plot that number against the year that the case was created. I have a column with the year. How could I do this? I have attached an example of my spreadsheet. In this example I would want a bar graph that says 3 cases for 2020, 6 cases for 2021, and 5 cases for 2022, regardless of if they are completed or not. Thanks!



  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭

    @jhorvath I am not sure where you want to hold or display the results? I would first build a summary field in that sheet, and then use a Sheet Summary Report to report on the results.

    =COUNTIF() is a fairly straight forward formula to use:

    =COUNTIFS(year:year, "2020", [case number]:[case number], >0) should count cases in 2020.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!