Getting records from one sheet to another sheet

Ask for Help
1

Hello team,

I have a spreadsheet with two sheets as below.
First sheet name : Bill

bill records
bill records955×296 40.8 KB

Second sheet name : Discount
discount
discount792×340 43.2 KB

I have added “Row owner” both sheets in glide table.

I want to get “discount column” records from discount sheet to add bill sheet’s discount column.
I am preparing bills based on 2022.01 see “month” column in bill sheets. therefore I need only discount records from discount sheet with 2022.01. There is one record 2022.02, I don’t need it.

Please help me on this.

Thanks,
Roshan Abrew

2

It might be quicker inputting the data by hand.

But if you want to automate and pull the data, I think you could for instance:

  • Bill table: Create template column, “SupplierID Month”
  • Discount table: Create template column, “SupplierID Month”
  • Bill table: Create single relation column between two columns above
3

Thank you!.. I used single relation method as per your instructions, it was worked well…