I originally references this from another site, but there hasn’t been any activity on it for 3 years, so I wasn’t hopeful for a response on my question.
I am attempting to utilize a calculated column to auto-populate the % completed in a Gantt Chart view. I am using 4 checkboxes to define the portion of the process completed, so each increment would go up 25% in theory. Checkbox 1 check is 25%, Checkbox 1 & 2 checked is 50%, etc. Below is the formula I am using.
=(IF([Test Cases Created]=TRUE,0.25,0))+(IF([Testing Completed]=TRUE,0.25,0))+(IF([Documentation Created]=TRUE,0.25,0))+(IF([Documentation Approved]=TRUE,0.25,0))
My issue is that I cannot figure out how to get it to populate to the Gantt Chart. The original walkthrough doesn’t state how the Calculated Column should be displayed (Number or Single Line of Text) & it site stated that a workflow needed to be created to change this to a simple number column so it can be used for the displayed result. However, the workflow listed doesn’t make sense to me and I feel like there is some information missing here in the steps to recreate.
If anyone can assist in helping me fill in the blanks here would be appreciated as I am thoroughly lost at this point. The link to the original walkthrough is http://sharepointsolutions.blogspot.com/2013/08/make-gantt-chart-more-than-gantt.html for reference.
Thanks!
P.S. I did not create the separate Content Type as I felt it was not needed since I already had a custom one and I also set the workflow to run on this one specific list instead of on the content type since this will be the only list I am running it on.
Hi Ken,
Basically what the problem is… is that Calculated Columns cannot be used in the Gantt chart, you need to store the value in another field. So what the workflow does, is just grabs the value from the CalculatedField and moves it to a number field.
So he actually creates two fields … One for the calculated column – “CalculatedCompleteness” and one to store the value of the calculated column called “CompletedPercentageForGantt”. Then he uses the “CompletedPercentageForGantt” as the value in the Gantt..
All of this, just because you can’t use a Calculated Column as the Gantt value 🙂
Does this help?
This totally helps! I got it working not after storing the value in the new number column via the workflow, it just took me a few to wrap my brain around it. Thanks a million!