column from another table in expression

[haplc]

Dear All,

I would like to use a column from another table in expression

I have a table "Alarms_SP". IN this table, I have following columns:
Zone1_temp, type Number
Zone1 Warning, type number
Zone1 High, type number
Zone1_TCN_Fault, type text

I am using following expression for the column "Zone1_TCN_Fault:

IFS(
([Zone 1 Temp] < [Zone1_Warning]), "Zone 1 temp OK",
AND (([Zone 1 Temp] >[Zone1_Warning] ) , ([Zone 1 Temp] <[Zone1_High] )), "Zone 1 temp warning",
([Zone 1 Temp] >[Zone1_High] ), "T1 over heat!",

)

However, in this expression, instead of "zone1_temp", I would like to use a column "Zone1_TCN1_MVChan1" from another table "signals"

I have tried [signals].[Zone1_TCN1_MVChan1] in the expression but that does not work

Please advice how to solve this issue? 

Thanking you in advance

[TeeSee1]

https://support.google.com/appsheet/answer/10108207?sjid=2392921709354553841-AP

You typically use a select statement or Lookup statement to get a value from another table. Or if you have a reference field to that table you can use a dereference expression.

[haplc]

Thanks TeeSee1, I tried but could not manage to get the value. 

What I would like to do is get the column "Zone1_TCN1_MVChan1" (which is part of another table) in "zone1_temp" which is part of present table. 

Which column should be defined as Ref column ? 

THanks

[TeeSee1]

How are the two tables, Alarm=SP and signals, related?

When you say you want to use "Zone1_TCN1_MVChan1", how do you identify the row you  want (assuming signals have multiple rows )?