Hello. I have developed a Script (Powershell), that will create a complete smartsheet. This smart sheet is created with colours based on various times on the source data, (Late, ontime, etc. ).
My problem is when I update it again, the first column will keep the shading of the previous entries. even though I specify a format. I have to go in and manually clear out the background colour.
the updated code is. something like this.
{"columnId": "<REDACTED>","value": "P55619","displayValue": "P55619","format":",,0,0,0,,,,,0,,,,,,"}.
Previously the grey background was across all columns, and it cleared on all the columns except the first.
