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