This is my first post in the community, and I’m super stoked to be giving back a little bit. Hopefully someone will find this useful
I discovered a hidden formula last night, and saw that there’s nothing in the Coda documentation or in the Community posts about it, so thought I’d whip up a doc to help explain what I discovered. I’ve certainly been having a ton of fun with it today.
The _GRADIENT() formula allows you to apply conditional formatting to tables far easier and with much more control than Coda’s conditional formatting editor.
Here are some perks:
- Use literally any color you want.
- Apply hundreds of colors to your tables with a simple copy-paste instead of setting up individual rules one-by-one.
- Your own Color Scales, with meaningful color stops that present your data better to your users.
- And finally, a little insight into how Coda stores colors internally, and how we can use this for some cool UI tricks.
There’s a lot to go into, so I think I’ll just share a link to my doc: