Gant charts do not recognize Percentage columns with formulas why?

Answered - Pending Review

Hello all. I have a gant chart and i want it to read a column of percentages i created with formulas dependent to other values, but my gant chart won't read the percentage column. Any ideas why that is or how to get around that? Thank you


  • Right click your sheet headings and click on edit project settings. Then make sure the column you have the %'s calculating in is set as the % Complete column.

  • Thank you @Hudson_TMR Turns out I have formulas in that very column that product my percentages IF another column has a certain text in it, the percentage column will then read "20%", "30%", etc. Do gant charts read percentages that are actually a formula? Is there a work around by chance? thank you!

Sign In or Register to comment.