Hey there, In a table, I have a column where the cells contain a formula displaying a result. This result is a string and happens to be the name of rows/items of another table I want to reference. How can I do that ? It seems using “@” does not work in this case. Thanks !

Maybe this will help: [image] Referencing Column Name from another table I have figured it out! I used the switch statement to check the type of battery used and then summed the corresponding column in the Toys table. =Switch( thisRow.[Battery Type], "AA…

I guess the switch function works when you have only a few possible values you need to transform into a reference. In my case it does not help. The reason why and what I am trying to achieve is best explained in the framework of this discussion though [image] Dropdown Columns via a…

Sorry, I mistook rows for columns. :upside_down_face: I replied to the specific case on the other thread. Going back to the original question here: Say you generate a string through a formula, you can use either Lookup or Filter to find the correspondent row from another table: Keep in mind thi…

How to use the result of a formula as a reference?

Dalmo_Mendonca July 2, 2019, 10:46pm 2

Maybe this will help:

Topic		Replies	Views
Using @ references to other tables in formula	2	313	October 20, 2023
Reference other columns after using the @reference	12	3713	February 20, 2025
How can i reference a named formula in each row of a table?	2	759	October 23, 2019
How-to? Selecting row from another table in formula	8	3528	August 22, 2022
Referencing Column Name from another table	6	2158	August 29, 2023

How to use the result of a formula as a reference?

Related topics