Softwareand one named
Softwaresheet has a
Supplier Namecolumn and the
Suppliersheet has a
Namecolumn. But there's no link between them (because it's a spreadsheet)
SupplierThen you can make it automatically link when
Supplier Namefield in your spreadsheet with the correct value. This makes it much easier to work with, as it introduces better filters, better views and better permissions.