Project Online Custom Field Formula Issue RRS feed

  • Question

  • Hi All:

    I'm trying to create a project-level custom field with a formula.  The formula should differ depending on if the project is an Enterprise Project vs. a SharePoint Tasks List.  From using PowerBI, I see that there are Project Online fields called EnterpriseProjectTypeName and EnterpriseProjectTypeID that would work for my formula.  However, Project Online doesn't seem to recognize these fields. 

    Listed below is the formula that's erroring out:

    iif([EnterpriseProjectTypeName] = "SharePoint Tasks List", 2, Format([Task Temp] / [Total Tasks], "0.000"))

    Basically, set the field to 2 if it's a sharepoint tasks list, and calculate the value if not.

    Is there something I'm doing wrong with the above formula?  Is there a way for me to test the project type in a formula?

    Thanks in advance for your help!

    Ken Zwyers

    Friday, April 5, 2019 4:13 PM