Launched: Progress bar column type and more features for project trackers

Coda’s tables provide the building blocks to create a collaborative, customizable, and organized space for project tracking. And with the launch of new improvements, we’ve powered up the ability to plan, communicate, and optimize your work:

  • The new progress bar column type and page control provide a clear visual indicator of project progress. 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.

Progress bar new.gif

  • 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.

6-9-22 Progress bars.gif

  • 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.

Progress canvas control.gif

  • Using bulleted lists within a cell is simpler than ever. Just hit enter to keep adding to your list—no keyboard shortcuts needed for your note taking, deep thinking, or communicating.

Bulleted lists.gif

  • Add table views to your page more quickly and easily from the table menu. These views are linked, so modifying your data in one place will ensure consistency and clarity across your doc. Customize your data visualization for all your needs at the click of a button.

62b1d1c630668270056626

  • A new duplicates formula allows you to quickly and easily identify erroneous, duplicate information in growing tables of information, like OKR trackers—supporting you as you manage your large teams and even larger batches of data.

Duplicates formula.gif

You focus on growth, progress, and communication— our building blocks make it simple to manage. We included some of our frequently used project trackers below if you want to quickly spin up a tracker today.

26 Likes

This is awesome! Love the color change. If you prefer to use Hillcharts for the visual you can do this in Coda too: https://hillchart.app
image02

12 Likes

These are amazing! And I so have needed the duplicate formula and am going to use it right now instead of the long workaround I had before :). Thank you.

2 Likes

Conditional formatting is not working for us to color the bar itself vs the background of the cell.

E.g.

1 Like

use conditional formatting to change the color of the cell’s TEXT to change the bar color

max

3 Likes

I thought so as well, which prompted to find an insane workaround.

It actually will work if you set progress bar’s color to the default blue (the first option in the settings). Then text color of that conditional format rule will be used onto the progress bar. Both the default 8 and the advanced palette of colors will work.

5 Likes

An amazing set of updates…looking forward to trying the bulleted list keystrokes and conditional formatting on the progress bar.

4 Likes

You’ll hear more from the team soon, but progress bar color gradients are now available! You can choose from several options in the column or control settings.

1 Like

Something’s wrong with the gradients though:

ezgif.com-gif-maker (46)

Seems to work for me:
image

Sky test en try · progress bar

2 Likes

@Paul_Danyliuk when you have a moment, can you send your doc to our support team (support@coda.io). We’re happy to take a look, thank you!

No need, that’s just a regular continuous white-to-green (not red-yellow-green) gradient that has a wrong stop perhaps.

This is reproducible with all continuous gradients. There’s a point at about 60% where the color becomes the most vibrant and then gets paler at 70% before going more vibrant again at 100%

Maybe there’s a color stop with a different hue but the gradient is then interpolated incorrectly (e.g. with linear RGB instead of HSL)

1 Like

Ah, I understand what you noticed, sharp eye for detail.
This makes it easier to see:

4 Likes

Nice catch, we’ve found the issue and are deploying a fix. The correct color blending will show up in a couple days.

Update: This is now fixed.

4 Likes

Meanwhile my previous hacking efforts didn’t go in vain — I just black magicked custom gradients:

Style options are smooth and segmented. Colors can be HEX or named {colorId, shade} Coda colors (light/dark mode adaptable).

For solid colors just use "type" : "SolidColor", "colorId" : "NamedColorId". Hex won’t work here, only named colors.

3 Likes

@Paul_Danyliuk This was very cool to examine. So by rendering a JSON object in the Progress Type column, since its expecting that, it can just parse it and display the JSON. Very cool and good to know.

How did you find all the key pairs that construct the json object for the output?

something like: thisRow.Output._merge().ToText()

1 Like

This is awesome - thanks!
Anyone know how it would be possible to remove the adjacent value text?

There’s a setting for that:

image

1 Like

Thanks for getting back to me, I should have mentioned that when implementing your solution above, the control settings seem to be overridden. I assume there’s another key pair or something to set it.