count number customers briefed by quarter

Options
bshokrol
bshokrol
edited 12/09/19 in Smartsheet Basics

Hi, 

I have a date column which shows the date we briefed a customer, I want to determine how many customers we briefed in each quarter and eventually by month. The column property is "date" and I cannot change that. 

 

=COUNTIFS([Date Briefed:Date Briefed], >DATE(2017,07,31), [Date Briefed:Date Briefed],<DATE(2017,11,01))

I tried this but the result is unparsable

I have tried not using the DATE function but that doesn't work either. Any suggestions?

--B

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    If your Column headers contain spaces surround each reference with brackets. I was able to run a similar formula on End dates in a text/number formatted column. 

    =COUNTIFS([Date Briefed]:[Date Briefed], >DATE(2017,07,31), [Date Briefed]:[Date Briefed],<DATE(2017,11,01))