Solved: Help With Referencing a Column - Page 2

nimble777 · 01-31-2020 09:46 AM

Hey App Sheet Community!

I have been struggling with referencing a column from one table to the other. Could you please help me?

I have been trying to transfer the list of names in my table called “Names” under the column “Client” into my column called “Client Name” in my table called Billing AR and AP.

I have been trying at this for about 38 hours now and have had too much coffee…Can someone share an expression or any insight that would help me achieve this?

Thank you so incredibly much.

Sincerely,

Wesley
#Caffeinated #column-expression #extractcolumnfunctionplz

Steve

Have you read through and do you understand these?

If you want to use a Ref (reference) to access data from another table, the table you’re in must have a column of type Ref that references the table from which you want to get data. Do you have this? If so, please provide a screenshot of its edit-column screen.

The Ref column’s value for a given row must be the key column value of a row in the referenced table. Do you have this?

View solution in original post