How can I resolve the issue of date fields being converted to a JSON format and currency fields not being recognized as numeric when exporting data from the Data Bridge to Google Sheets?

When exporting data from the Data Bridge to Google Sheets, date fields may be converted to a timestamp format and currency fields may come through as plain text. To resolve these issues, you can use specific formulas in Google Sheets to reformat the data:

For date fields, use the following formula to convert the timestamp to a date format:

=int(CELL_NAME)/1000/86400 + DATE(1970, 1, 1)

For currency fields, you may need to write a custom formula to strip out any non-numeric characters and convert the text to a numeric value.

We are actively looking into integrating these functionalities directly into the Data Bridge for improved usability. In the meantime, these formulas should help you build your reports more effectively. If you have further questions, please reach out to support.