I am encountering difficulty in using COUNTIFS formula to count the items with active dates within the quarter of the year. I tried the below formula in Excel spreadsheet and it worked well. However, the formula doesn't work in Smartsheet.
Formula in Excel spreadsheet:
=COUNTIFS(D1:D344, ">=10/1/2016", D1:D344, "<=12/31/2016")
Formula in Smartsheet:
=COUNTIF([ACTIVE DATE]1:[ACTIVE DATE]344, "<10/01/16")
=COUNTIFS([ACTIVE DATE]1:[ACTIVE DATE]344, ">=10/01/16", [ACTIVE DATE]1:[ACTIVE DATE]344, "<=12/31/16")
I wanted to obtain the count of items activated each quarter of the year.
Someone could help me out please. :-)