Welcome!

count number customers briefed by quarter

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

Find more posts tagged with

Comments

Mike Wilday

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))

Sign in to join the conversation!

Quick Links

Trending discussions

Changing cell value automatically based on form responses
I have a form that will be filled out internally. There's a cell labeled "Department" which contains 8 dropdown list values. There's a another cell called "Executives" which are the leaders of these departments. In the form, I'm attempting to do a logic where when you choose a specific "Department", then the cell…
Limiting Access to Folder and it's assets
I shared access to a user to a specific folder under workspace A (folder is 2025-09-Service Factory). However, I can see that he's shown to have access to all the other child folders under 02-ACTIVE Initiatives. Why is that when I only shared out one folder? Is there a way to only share access to users to ONLY specific…
existing files can't be open after change my plan to Pro
what i can do if all my existing smartsheet gant files can't be open after change my plan to Pro? what could be the reason ?