Hi. I have a scenario to take data from Google Sheets, and update it in Airtable. I’ve noticed that fields formatted as currency in google sheets, get passed on to Make say €100.55. This value failes in AirTable, as it expects just 100.55. Same for anything with a percentage, you get the value from Google Sheets as say 15.6%, while AirTable then expects it as 0.156.
Is there an easy way to normalise such values, without having to change the Google Sheet formatting?