Unable to update row in table ‘Lab Section CC: Analytes’. → The service sheets has thrown an exception. HttpStatusCode is BadRequest. Invalid data[0]: Requested writing within range [‘Lab Section CC: Analytes’!A3], but tried writing to column [P]: Message[Invalid data[0]: Requested writing within range [‘Lab Section CC: Analytes’!A3], but tried writing to column [P]] Location[ - ] Reason[badRequest] Domain[global]
and
Unable to update row in table ‘Lab Section CC: Enzymes’. → The service sheets has thrown an exception. HttpStatusCode is BadRequest. Invalid data[0]: Requested writing within range [‘Lab Section CC: Enzymes’!A5], but tried writing to column [P]: Message[Invalid data[0]: Requested writing within range [‘Lab Section CC: Enzymes’!A5], but tried writing to column [P]] Location[ - ] Reason[badRequest] Domain[global]
I always receive these when I try to edit ‘Status,’ which is recorded in Column P of my Google Sheet. Column A contains UID. Only in CC Enzymes and CC Analytes do I encounter these problems. There are no problems in updating the ‘Status’ in other sections.