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

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.

Answer 1

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

---

http://alecpojidaev.wordpress.com

Answer 2

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.

Answer 3

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.

---

http://alecpojidaev.wordpress.com

Answer 4

Thanks Alec.  That worked for me.

Answer 5

Nice. But looks like that worked for you not good enough to mark helpful post as the answer. Well... i dont have better workaround :)

---

http://alecpojidaev.wordpress.com