Referencing a 3rd table, how do I deference that table ?

[JLC]

Hello!

I have three tables:

Table 1 : ProfitCenters

ID (key)

ProfitCenter (label)

Table 2 : Project

ID(key)

Description

Project_ProfitCenter  (Ref to ProfitCenters)

Table 3: Request

ID(Key)

Description

ProjectID (ref to Projects)

ProjectProfitCenter

Projects ref to ProfitCenters and Request Refs to Projects. 

I was using [Project].[Project_ProfitCenter] to auto enter the profit center from the Projects table but the return value is the ID rather than the label in the Request table. I know I need to deference to the original table but I'm not understanding how to get that value. I tried ProfitCenters[ProfitCenter] but that is a list and I only need to return the text value of profit center associated with the Project. 

[Suvrutt_Gurjar · Accepted solution]

Please try 

[Project].[Project_ProfitCenter].[ProfitCenter]

Please check the last section in the article below

https://support.google.com/appsheet/answer/10107396?hl=en