I think I gave a follow-up to the cents formula too soon.
I created new records in Airtable using Integromat, from GS. I noticed that there was an added zero to the currency, in the formula field, in Airtable. My other field is a currency field. Could this formula work with a currency field and an adjustment to the formula or change the currency field to text and also, change the formula? Although, I would preferr to keep the currency field, since there are other sources that I will use data from, to create/update records in Airtable. It’s just this source of data that the currency is not formatted properly.
I should also mention that when I enter the currency, without decimals, directly into Airtable, the currency is formatted correctly. It’s when I have the data imported, through Integromat, using the currency without added decimals (source data), that I get the added zeros. Could it have to do with the currency format in GS? The GS format is at zero decimals and the cell format is automatic. That’s the only difference that I could think of, that’s different.
The currency field for Airtable is set at 2 decimal places with a dollar currency symbol and it allows for negative numbers.
I have attached screenshots to better explain the issue. Disregard the left side screen in the third screenshot.
Thank you for your help and patience.