I am using an importrange query from other sheet to filter data: https://docs.google.com/spreadsheets/d/1FbeoKhiJ3jqYXqfIgAK_tHXPZ_Z1Xrm33ulu9gomXuE/edit?usp=sharing
The "colors" sheet has data populated from query ("items" sheet) and users are allowed to write comments on each row.
Problem: if row order is changed on "items" sheet, the "colors" sheet row order will be lost and any previous comment will not match the correct row.
How can I prevent this? Is there a way to keep paired query row results and comments? Maybe using timestamp as a reference?
At the moment sheet "colors" contains a correct pairing, once a row is inserted between "items", the pairing is lost