Project ID coding "DEP-YEAR-#" RRS feed

  • Question

  • Hi,

    I'm looking to create a formula for the project ID to make it dependent on a selection in another field. Is that possible?

    If so, I want my project ID to select the 3 first characters from department-then add "YEAR"-"Sequence Number").


    • Department: Procurement
    • Year: 2018
    • Sequence Number: 5

    Project ID: "Pro-18-5"

    Wednesday, March 7, 2018 9:03 PM


  • Hi Henrik, 

    No this is not possible. You cannot make it dynamic, except for the increment. It would be a custom development to create a project ID with those business rules.

    Hope this helps,

    Guillaume Rouyre, MBA, MVP, P-Seller

    Thursday, March 8, 2018 7:00 AM