CountIFs EOM Formula
Options
@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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!