Automatic update to count values within a specific month
Hi, I currently use a countifs formula to count the number of met criteria within a given month. Data is entered monthly through a form. What formula can I use to automatically update the month automatically? The below formula works, but I have to manually enter the first and last day of the month in its respective column.
=COUNTIFS({Date}, >=[1st Month]1, {Date}, <=[Last Month]1, {Time Out Audit Range 3}, "met")
Answers
-
Try something like this...
=COUNTIFS({Time Out Audit Range 3}, "met", {Date}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(MONTH(@cell), 0) = = 2020))
Just update the 1 and the 2020 for whatever month and year you are wanting to count for.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!