Conditional Formatting Not Working When Copying from Google Sheets

1

Hi.

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.

image
image812×666 28.3 KB

Thoughts?

2

Could you share the doc/ a copy of it?

3

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