Can you help with a formula to count the number in orientation by month from the picture below?
Options
Answers
-
You could try something along the lines of...
=COUNTIFS([Orientation Date]:[Orientation Date], AND(IFERROR(MONTH(@cell), 0) = ##, IFERROR(YEAR(@cell), 0) = ####))
Just replace "##" with the month number and "####" with the year number that you want to count for.
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!