I have a list of tasks, which I use to create a Gant view. If I point the gant percentage complete to a calculated field in the list I get "This list cannot be displayed as a Gantt chart because it lacks required fields", If I point to a number field which i manually have to update the percentage complete, it works fine.
If I link the list to excel, and use excel to do the calculation and then sync the list with sharepoint, to a number field, it also works, except that it then removes my formulat in excel.
Any help appreciated.
- Moved by Mike Walsh FIN Thursday, September 17, 2009 6:14 AM not customization (From:SharePoint - Design and Customization)
It should be a known issue that calculated field isn’t intended to be supported in the Gantt View even they display in the list of fields you can choose.
I am sorry that there is no hotfix to resolve it currently .
Thanks for your understanding.