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.
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.
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.
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.
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.
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.
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.
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.
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.
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)
@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?
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.