Conditional Formatting Not Working When Copying from Google Sheets


I’m currently syncing from a Google Sheet.

A particular column asks sales reps what the annual revenue potential for new deal. When syncing the column from Google to Coda, I can convert the column to a currency column. However, when I apply conditional formatting so high value deals are more green than low value deals, all rows are the same shade of green.

Even if I try to create a duplicate column that converts the value to a number, the rows are still the same color.

The only way it works correctly is if I manually type values in my duplicate column instead of using the calculation option.


Could you share the doc/ a copy of it?

Hi. I was able to fix it by simply creating a new column that references the column syncing from google and multiplying by 1.

1 Like