This list cannot be displayed as a Gantt chart because it lacks required fields RRS feed

  • Question

  • I have built a form in infopath and published it to sharepoint 2007, creating a library for it.  I created a Gantt view for it and it all works fine, except the % complete.  I can't figure out, how to get my % complete data field in the form to relate to the % complete the Gantt chart is looking for.
    • Edited by phanifee Tuesday, April 14, 2009 7:47 PM edit spelling
    Tuesday, April 14, 2009 7:46 PM

All replies

  • It's just a number type field with checkbox "Show as percentage" is checked.  So your related form field should be numeric field with values range from 0 to 100
    • Edited by Alec Pojidaev Tuesday, April 14, 2009 7:59 PM more info
    Tuesday, April 14, 2009 7:56 PM
  • I must be missing something then.  My infopath form has a text box with data type as whole number.  I don't see a way to set a numeric field range on it.  Forgive me, I'm new at this and learning on the fly.  Even with the field as a Whole number, whenever I associate it to the % Complete in the Gantt chart view, it gives me the above error.  I know this has to be easier than I am making it, but must be missing something.
    Wednesday, April 15, 2009 1:32 PM
  • Yes you are right, we can't promote number type infopath field to the number type column in form library. The usual workaround in such cases is to create a calculated column with formula = VALUE(YourPromotedColumnHere) and then use that calculated column in Gant view.
    Wednesday, April 15, 2009 3:51 PM
  • Thanks Alec.  That worked for me.
    Wednesday, April 15, 2009 6:14 PM
  • Nice. But looks like that worked for you not good enough to mark helpful post as the answer. Well... i dont have better workaround :)
    Wednesday, April 15, 2009 6:21 PM