Google sheets row data identified but update does not work

A post was split to a new topic: Unable to create new rows in my Google Sheets with some columns containing predefined formulas