Lookup Table value vs. description RRS feed

  • General discussion

  • I have PWA 2010 and Project Pro 2010.  I have a enterprise custom field with a enterprise lookup table.  How do I get the lookup table description to show up when I group on it in Project Pro 2010?  The value shows up for each grouping.  I posted here because it worked when I used a local lookup table.

    Long Live America

    Tuesday, June 12, 2012 12:54 PM

All replies

  • Hi there--

    If you have a lookup table defined with value & description in PWA, when you associate the lookup table with custom fields & view the Project information in MS project, It shows you the lookup value & description.

    Does that help?

    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog:

    Wednesday, June 13, 2012 6:08 AM
  • Hi Amit,

    I am not seeing that.  They are associated in the server, and I see the value in Project Pro but I want to see the description.

    Long Live America

    Wednesday, June 13, 2012 2:16 PM
  • Hi there,

    If you click in the cell of a lookup table field to select a lookup table value, the drop down list will show the description.



    Paul Mather | Twitter |

    Wednesday, June 13, 2012 2:30 PM
  • Ok, It looks like below: MS project> Project Tab> Project Information> click the Custom field value cell which has lookup table (value & description), in below case, CF- Status_tech & values 1, 2, 3 & the description-

    Hope that helps.

    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”.
    Thanks, Amit Khare |EPM Consultant| Blog:

    Thursday, June 14, 2012 6:26 AM
  • Hi Vassily,

    what type of enterprise custom field are you talking about? Project, Task or Resource? As far as I understand your post, you refer to a custom field on task level. And you want to group your tasks by this custom field and show the description of the custom field in the grouping row. Is that correct?

    If yes, I dont think it's possible, sorry.

    Best regards,


    • Edited by Axel Hammer Thursday, June 14, 2012 7:23 AM
    Thursday, June 14, 2012 7:06 AM
  • What I am trying to do is:

    Instead of this (which shows value):

    Long Live America

    Thursday, June 14, 2012 1:22 PM
  • Is Do This (Which shows description):

    Long Live America

    Thursday, June 14, 2012 1:25 PM
  • Yes Alexander, you are correct about what I am trying to do, and it is a text field.

    Long Live America

    Thursday, June 14, 2012 1:37 PM
  • As mentioned above, I dont think it is possible. You may consider creating an additional formula custom field on task level, e.g. "Field Description". Within this you determine the description via formula (e.g. Iff( [Field] = "A"; "Description for Item A; Iff( [Field] = "B"; ...)

    Then you can group your tasks by this new column and the description appears in the grouping rows.

    Please be aware that (too many) custom fields on task level and esp. formula fields may have an impact on the performance of your project server.

    Tuesday, June 19, 2012 2:00 PM
  • yes, it appears this is not possible.

    Long Live America

    Tuesday, August 7, 2012 2:13 PM
  • This s not possible using the out of the box features as far as I'm aware. Since the lookup value is an enterprise field you could go to the extent of creating a custom report which joins the custom field back to the corresponding MSPLT_CustomFieldName... table to extract and group on the Description (MemberDescription).

    Not sure but you may be able to create some VB code to extract the desription and store it in another custom field in the schedule


    Piet Remen

    Tuesday, August 7, 2012 3:31 PM