Count the number of Cases by Month

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • In Progress
So I'm creating a custom reference with "SY-MM-YYYY-CASE-GENDER"
This my current formula:
"SY" 
& "-" 
& Month(ToDate([Date Created]))
& "-"
& Year(ToDate([Date Created]))
& "-"
Count(ToDate([Date Created])) <-- Current Problem
& "-"
& [Gender]

How to count the number of records by month using formula-text?
Photo of Hakz

Hakz

  • 122 Points 100 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,006 Points 50k badge 2x thumb
I think that you will need to take a step back and explain your use case.  If you want to count the number of Cases per month, you can just make a Summary report.

You may have a use case which does require the Values to be on records, and if you can explain that, there is likely a solution. 
Photo of Hakz

Hakz

  • 122 Points 100 badge 2x thumb
Example, I created 3 records this month so the formula-text i made will show "PE-01-2018" "PE-02-2018" "PE-03-2018" then if it's the new month the first record i create will be "PE-01-2018"