CountIFs EOM Formula
@Diana
✭✭
Is there and EOM formula that will use the Month Column instead of manually using the DATE (2019,1,31) format?
Excel example:
=COUNTIFS(Type of Lead,"Servicing",Date Received,">="&B5,Date Received,"<="&EOMONTH(B5,0))
Smartsheet:
=COUNTIFS({Type of Lead},"Servicing", {Date},>=DATE(Month1),{Date},<=EOM(Month1))
Any help would be much appreciated.
Comments
-
=COUNTIFS({Type of Lead},"Servicing", {Date}, MONTH(@cell) = 1)
Just change the 1 to a 2 for Feb., 3 for March, etc...
Or you could have an additional column (which can be hidden to keep the sheet looking clean) with the corresponding month numbers and reference that in your formula
=COUNTIFS({Type of Lead},"Servicing", {Date}, MONTH(@cell) = [Month Number]@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 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!