Skip to main content
JustinWa2
JustinWa2
Level 4
April 16, 2026
Solved

Active job report

  • April 16, 2026
  • 2 replies
  • 61 views

Hello!

I need to write a report that captures how many total active jobs there were in any given month of a year. My main problem is our active status’ are custom fields and WF doesn’t seem to want to work with those.

How do I get this report?

Thanks

Justin

    Best answer by Lyndsy-Denk

    Can you say more by “WF doesn’t seem to want to work with those”? If I’m guessing correctly, you’ll need some sort of date (start or completion, actual or planned) to group projects by the month they were active. The status changes over time from planned to in progress to complete, so if you want to see when it was actually active, you need some sort of data point other than the status.

    2 replies

    Lyndsy-Denk
    Community Advisor
    Lyndsy-DenkCommunity AdvisorAccepted solution
    Community Advisor
    April 20, 2026

    Can you say more by “WF doesn’t seem to want to work with those”? If I’m guessing correctly, you’ll need some sort of date (start or completion, actual or planned) to group projects by the month they were active. The status changes over time from planned to in progress to complete, so if you want to see when it was actually active, you need some sort of data point other than the status.

    ninoskuflic
    ninoskuflic
    Level 4
    April 22, 2026

    You can use also calculated fields for this use case - this is what I usually do if I need to capture when a status was changed and then I use those for reporting. 

    If this solved your issue, please mark it as solved so others can find the solution faster.
      JustinWa2
      JustinWa2Author
      Level 4
      May 14, 2026

      Thank you! I was able to get what I think is the correct data by using some of the fields you mentioned. Appreciate the help!

      RandyRoberts
      Community Advisor
      RandyRobertsCommunity Advisor
      Community Advisor
      April 23, 2026

      you can start with this calculated field on your project form:

       

      LEFT(IF(LEFT({DE:Project Status History_},LEN(IF(ISBLANK({status}),"-",{status})))={status},{DE:Project Status History_},CONCAT(IF(ISBLANK({status}),"-",{status})," (",$$NOW,") | ",{DE:Project Status History_})),2000)

       

        Terms & ConditionsAccessibility statement

        Loading footer...