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.