This is a fairly straight forward question and I think I might know the answer, BUT here it goes. The completion status bar within the task bar is typically driven by the % Complete column. It appears that column (for the bar to work correctly) has to be manually entered. If I use a formula, it will give me a % but will not update status bar. Is that a correct statement or can this be worked around?


Hi Mindy,

That's correct! Project columns, like the % complete column, don't support formulas when dependancies are enabled. If needed, more information on this can be found in our help article: https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors#Complete

This would be a great opportunity to submit a Product Enhancement Request (you’ll find a link to this here in Community under Quick links on the right).