Thanks @Stefan_Stoyanov! For this release we optimized colors which retain a readable contrast with black text. We’d love to offer darker options including some that work with white text in the future. Great suggestion on grey scale as well.
4 Likes
How do you configure this?
Hi @Johg_Ananda ,
You can view the presets by adding a conditional format to any numeric column:
2 Likes
OK so you’re saying the presets themselves are set for the max/min/midpoint? how do we know? Do they indicate it or we have to figure it out? I’m confused.
Yes. To provide a bit more detail, we currently provide presets that generate a gradient across 2-3 colors. In the screenshot below, I’ve selected the [red, yellow, green] preset. If you apply the option to the dataset [1, 2, 3, 4,…,10], red will be assigned to 1 (the min), yellow will be assigned to 5 (the average), and green will be assigned to 10 (the max). Then, we do a linear gradient through those points to generate the in-between colors.
Does that help?
@betty this is very thoughtfully designed, thank you!
Can you please add a feature request for more control over where the gradient shifts?
- example) Google sheets gradients can highlight the newer dates last updated by pushing the midpoint percentile to 90
2 Likes
@jeo Thank you for sharing your scenario! The feature request is definitely on our radar. We released a first milestone to unblock basic scenarios, but do plan to support more customization in the future!
5 Likes
Hey @betty !
I don’t think the colour scale / gradient renders properly when in card view for some reason. It looks like we get the extremes but not the in-betweens. here is a photo for reference
Hey @Colin_Nickerson ,
Thanks for flagging the bug! Just put in a fix for this, and it should be deployed either today or tomorrow.
1 Like
Is this feature only available for Doc Makers? Can Editors use this too?
@Irish Yes! As long as the table is not locked, you should be able to use this feature, just like any other conditional format. Are you not seeing the option?
Thanks @betty but I’m not seeing that option on my end.
Hey there @Irish - You can also check if your column is formatted as some sort of number column.
If you have numbers in your column but it’s formatted as text it won’t give you the option for color scales
2 Likes
THis first version is GREAT! well done.
I know from experience how hard it is to come up with a color gradient algorithm that looks good AND still allows the text to be legible across the whole range.
BUT
These wonderful colors dont show up everywhere the fields are used; for example in detailed view navigation pane and when used for grouping. so much information is encoded in colors, its a great pity to lose that in so many places in the interface. just saying… if you are wondering what to spend your new millions on… ya know? 
max
2 Likes