When Sheetgo transfers data from a source to a destination, it will identify the following formats:
Numbers
Dates
Formulas
Sheetgo will automatically parse and paste values into the destination sheet according to the format it recognizes.
Data transfer errors
In some circumstances, Sheetgo may incorrectly identify values as numbers, dates, or formulas.
This includes:
Phone numbers starting with +
Codes starting with 00
Codes that resemble dates
Value in source | Recognized format | Value pasted into the destination |
0005 | Number | 5 |
+49784621221 | Formula | #ERROR |
If numerical values are being pasted incorrectly into your destination sheet you can deactivate the Parse Data setting to paste values as raw data.
How to change the Parse Data setting?
Open Sheetgo and create a New workflow or edit an existing connection.
Under Destination > Advanced Settings, go to Parse Data.
Uncheck the box labeled Convert text to numbers, dates, and formulas.
Sheetgo will now paste values into your destination sheet as raw data every time the connection is updated.
Need more help?
Contact us via chat, on our email ([email protected]), or send us a ticket!
Visit our Community for help, tips, tricks, and feedback for Sheetgo.