Hi,
I want to combine 2 separate columns of Table1 & Table2 into a column in Table3. Below I prepared an example scenario in Google Sheets:
Is this possible?
Thanks!
Hi,
I want to combine 2 separate columns of Table1 & Table2 into a column in Table3. Below I prepared an example scenario in Google Sheets:
Is this possible?
Thanks!
I solved this problem and here I am sharing if anybody else wants to do the same thing below.
This is the data structure and table design:
Here is the formula as a text for convenience:
list = (Table1.lookupRecords().categoryID + Table2.lookupRecords().categoryID);
if($id-1 < len(list)):
return list[$id-1]
else:
return ""
You need to adjust Table1,Table2,Table3 and vehicleID for your cases of course.
Hope that helps somebody like me
You can ask me on Twitter if you are stuck, I can try to help: https://x.com/_burakkurkcu