Forum Discussion

ANS_Admin's avatar
ANS_Admin
Qrew Trainee
7 years ago

Count the number of Cases by Month

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?
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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. 
  • ANS_Admin's avatar
    ANS_Admin
    Qrew Trainee
    7 years ago
    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"