Count the parent row if the finish date is in the current month

FusiaSuede
✭✭✭
I am trying to create a formula that will count the finish dates in my parent rows if it falls in the current month.
I know how to use the month formula but I would have to update that every month and ideally, the current month formula will follow the calendar, thus not requiring me to update at the first of every month.
Answers
-
I think you're looking for:
MONTH(TODAY())
That should return the current month number to be compared with your other dates.
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!