Fix a google sheet script/function that sets colors in a cell.
Budget: $30 – $250 USD
We have a google sheet that we use to set a list of complimentary colors that are generated from a script.
There is a problem where the SetColor() function does not work. It may be due to color pallet limitations or something else. One think for sure is that between sheet resets, the script is more successful if all cells are cleared of colors.
All cells with SetColor() function need to update the color when the refresh button is pressed. C2 is the only input cell.
We will make the sheet view only so you can make a copy and review the code. Here is the link:
https://docs.google.com/spreadsheets/d/1PLgj-3GQMLzSALii7uBZXraqVcCpUUxSoxTPvuOyOD8/edit#gid=1706271092
See screenshot as an example of the sheet. We will pay a max of $50 for this. It must be fully tested and verified working when delivered.
To show that you read this completely and did not spam bid without reading, but your favorite google sheet extension, add-in, or library as the FIRST words in your bid.
There is a problem where the SetColor() function does not work. It may be due to color pallet limitations or something else. One think for sure is that between sheet resets, the script is more successful if all cells are cleared of colors.
All cells with SetColor() function need to update the color when the refresh button is pressed. C2 is the only input cell.
We will make the sheet view only so you can make a copy and review the code. Here is the link:
https://docs.google.com/spreadsheets/d/1PLgj-3GQMLzSALii7uBZXraqVcCpUUxSoxTPvuOyOD8/edit#gid=1706271092
See screenshot as an example of the sheet. We will pay a max of $50 for this. It must be fully tested and verified working when delivered.
To show that you read this completely and did not spam bid without reading, but your favorite google sheet extension, add-in, or library as the FIRST words in your bid.