“Should I sort this data in descending order by values in my number column to show a trend? Or should I sort this data alphabetically by a text column so my viewers can quickly scan for the rows that matter to them?”
With today’s update, hopefully this a question you get to ask yourself much less frequently.
Now, instead of creating a variety of rules with your conditional formats or formulas, you can see trends in numeric data and spot outliers with a single conditional formatting rule. Like our other conditional formats, color scales apply to a single column by default, but you can extend them to other columns and/or entire rows.
With this first version of color scales, we’ve enabled presets based on min, max and mid-point values. In the future, we hope to offer more customization, support for formulaic scales, percents and much more. Hopefully this first step helps you visualize your even more powerfully in Coda!
Yes, this is fully rolled out. Create a new doc and give it a try on a number column. If you have an existing doc and you are trying it on a number column and still not seeing it, you can write into support and we can check.
Yep, if you’re not seeing any feature we launch, I’d always suggest refreshing your tab. Most updates we push will not happen automatically. You’ll have to reload the tab yourself to pick up the changes.
One thing I would like as a selection is a simple negative = red, zero = white, positive = green for eg. currency columns. So if I understood correctly, forcing the midpoint to be 0.0 the max and mimimum could be still using the real values, providing that max > 0, min < 0
Something like:
Set 0.0 as the mid-point (default is average of the values)
Also the color scales seem a bit harsh, I’d prefer a bit more suble colors to keep the text easily readable.
In addition It would be great if I could create my own color scale of five different text/background combinations.
So maybe have the scales provided by Coda and below that custom scales per doc. Or at least one custom scale per doc, shared by all tables.
We’d love to enable positive/negative, different colors and other settings! For this first release we focused on a few common presets, but designed the underlying model with flexibility so we can offer more customization in the future.
Thank you so much, you folks are amazing!
cmon Codan, y’all start freaking me out!
