Gant charts do not recognize Percentage columns with formulas why?
Answers

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!

EDIT: Nevermind, I thought this was working but after inputing a brand new line it does not. It will insert the formula as a string 🥲
I suppose we are still looking for this solution then...
I know this is a dead thread but I was able to find a work around for showing percent complete from a "column formula" that I haven't seen anyone recommend. The trick is to make your formula actually a cell formula but that is automatically entered with an automation. That way you don't have to manually pasted your formula, the automation puts it in there when say the row is created or whatever trigger you want. That way it always has the formula but you don't have to put it in yourself. So for instance I did this to make a "soft" column formula. This makes it able to be selected in project settings as percent completed! (the =INDEX(COLLECT()) formula being my method for fetching percentages)
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.9K Get Help
 379 Global Discussions
 210 Industry Talk
 441 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 300 Events
 33 Webinars
 7.3K Forum Archives