none
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").

    Example

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

    Project ID: "Pro-18-5"

    Wednesday, March 7, 2018 9:03 PM

Answers

  • 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
    Moderator