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!
Answers
-
@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.
dm
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!