Countifs by Month
I am familiar with =COUNTIFS({Start Date}, >=DATE(2018, 10, 1), {End Date}, <=DATE(2018, 10, 31), {Classification}, ="Lost Time Injury")
Wondering if there is an easier way to get this?
This is pretty tedious when you're just looking for what happened in a particular month of the year.
Regards
Steve
Comments
-
Have you considered exporting the report or sheet and then doing a basic pivot in excel? You could use the connector to pull the data into an excel template if you wanted to create a custom report? Depending on your use, you might be able to make a more generic formula that references the date outside the cell, i.e. put the date at the top of the column, and then have a row for each type of absence?
-
This works thanks for that.
Steve
-
Could you use something similar to count multiple classifications?
-
You can. If you are able to give me some more details as to the layout and format of your sheet and whatnot or even some screenshots, I may be able to help you with that.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!