My sales team add items to orders that are free sometimes. The initial value in the price column is “0.00” (not set by me in initial value option in the table) but saving to the googlesheet seems to have started saving a blank cell rather than “0.00”. They have to actualky type “0.00” into the field even though it already shows that.
If they don’t and a blank cell is crated than Zapier doesn’t like it when exporting to Xero.
In have added an action that lokks for blank cells and changes to “0.00” but it’s another action to take when it seemed to print “0.00” without it before.