Add a column in your tracking table to reflect the status of each task—rather than the project as a whole—to manage every piece of the puzzle.

To match the color of the bar with the progress made, you can use conditional formatting to set the column’s text color based on the progress number. Dynamic coloring for progress is currently loading, so you can expect a column setting for easy color gradients soon.

On a page, these bars can formulaically reference a summary of your tasks, so you can see a comprehensive view of your project progress at a glance.

Simply use the value input to add a formula to output the average status of all tasks in the progress bar column.