Concatenate values from reference sheets

[TigranKarapetya]

hello everyone. I have a different sheets connected each other with references. I need to bring some values from some columns in reference sheets to one cell in main sheet in every row. I Concatenate(), but its brings all column volues ensted of rows conected with ID

[Rafael_ANEIC-PY]

Hello there @TigranKarapetya 

We're going to need some more context to give you any specific suggestion

1. What are the names of the sheets/tables?
2. What are their columns?
3. Which values you want to reference?
4. How does the expected concatenation look like? any examples?

[TigranKarapetya]

Main table name is "MAIN" and its has a reference table named "Stock".

each row in MAIN can have a feu reference rows in Stock sheet.

My problem is being all that data from reference rows to one cell in main table

[Rafael_ANEIC-PY]

I see, that answers my first question, but there's still 3 to go:

---

@Rafael_ANEIC-PY wrote:

• What are their columns?
• Which values you want to reference?
• How does the expected concatenation look like? any examples?

---

[TigranKarapetya]

Structure are this . it's a basic task management system. each task can be assigned to different users. Each user after working on task adding row in reference table (named Stock) and chusing used goods. All calumn types are "Text" . I trying bring all that rows in one cell in "MAIN" sheet seperated with "***".

i apologize for my english 🙂

[dbaum]

Referencing a Column value in a Table, versus refe... - Google Cloud Community

Dereference expressions - AppSheet Help 

[Rafael_ANEIC-PY]

Well, I'm sorry but I don't think I can help you, I don't speak the language your column structure is made in, I don't even recognize most of the characters in order to attempt to google translate it, but I encourage you to take a look at the sources @dbaum linked in his post:

---

@dbaum wrote:

Referencing a Column value in a Table, versus refe... - Google Cloud Community

Dereference expressions - AppSheet Help 

---