Help

Re: Color-code Cells in a Pivot Table

675 1
cancel
Showing results for 
Search instead for 
Did you mean: 
JBJ
6 - Interface Innovator
6 - Interface Innovator

On a dashboard interface, I have a pivot table that counts the number of times a parameter (e.g. the ticket price for the exhibition) was mentioned by visitors in their reviews and I have those counts be computed for each venue (see Attachment #1). I would like to have cells be color-coded depending on their value: shades of green for the Strengths pivot table, shades of red for the Weaknesses pivot table. Unless I'm mistaken, as yet it's not possible to get this visualization feature on Airtable. Would you have any workaround to suggest?

Similarly, I'd like to get the same formatting on the table that's displayed on the PDF report that gets generated by Documint (see attachment #2). Any other PDF-generating tool to suggest that would allow me to get this color-coding?

 

2 Replies 2
thomas67
4 - Data Explorer
4 - Data Explorer

You're right that Airtable doesn't currently support native color-coding within pivot tables. However, there are a few workarounds that might help you achieve the desired visualization. 

You can export your pivot table data to Google Sheets or Excel, both of which have robust conditional formatting options. Once there, you can apply shades of green for strengths and shades of red for weaknesses.

JBJ
6 - Interface Innovator
6 - Interface Innovator

@thomas67, thanks for the advice. I'll look into an integration with Google Sheets.