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
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 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!