How to Keep Formula While Adding New Lines to Database

[ThinhDinh]

Is it possible to do a row to column relation

How can I relate rows to columns using similar Row IDs in different worksheets, Id like to do this because I have a sheet calculating lists but I won’t be able to view a specific inlist if it cannot relate to another string of data in a different sheet

If I’m correct, we did talk about the same thing here.

Your structure is weird. I believe a better way to do this is to have your rowIDs in the Panel list as one single column.

Let’s say:

Cabinet ID | Panel ID | Row ID | Quantity

Then in the second sheet have three columns

Row ID | Panel ID | Quantity

Then the quantity column can be derived using a rollup inside Glide on top of a relation, or an easier query inside the Sheet.