Add a lookup column as another field of the origin list

Copper Contributor

I have a problem with a Sharepoint List I'm working on: I want to insert a lookup column into my list to which I want to add 2 other columns of the origin list: one text(calculated based on a choice field cause I couln't include it otherwise) , the other is also a lookup field and therefore Sharepoint doesn't show the column as an option so I'm not able to choose it.

francescods9_0-1705507838309.png

 



Is there a workaround for this issue?
I need these fields from the source table because I would like to use them frequently as a filter in the child table.
Thank you.

0 Replies