Get Column Value from a Ref Column / Table

AppSheet AppSheet Q&A
, ,
1

Hello

I have a ref column and I would like to have another column that contains another value from the same ref row.
but the line should be updated automatically when the storage is changed

Like
Table1 [ID][name][Table2 - REF ITEM][Table2 - REF Store]

2

Have you tried to use a deref expression with the virtual column, something like [RefColumn].[ColumnName]?

1 Like
3

had already tried it but not as Virtual column, thank you very much

4

You’re welcome!

1 Like