I am using Bot with a color column in Google Sheets. When the hex starts with 00 (ie 008000) Bot runs through it and removes the first 2 zeros. Then the color in the project is not changed but takes the most recent color. Am I doing something wrong or is there a better way to ensure it accepts the correct color?
Dynamic Colors Issue?
The way to avoid the issue is to use a # before all hex values in spreadsheet data. This shouldn’t happen with JSON data, as it is a quirk of how spreadsheet software (including Google Sheets) attempts to detect the data type in a cell and set the formatting. Using # will override the Sheet from setting incorrect formatting while the Bot is processing its data. While the Bot is running, the Sheet will think that you are changing data, and will try to automatically format all-numerical hex values as numbers unless they use the #.