Is it possible to lookup a virtual column in one app from another app? I've had a look at LINKTOROW which allows me to link to the correct row, but I can't see a way to lookup a value within that row. It seems like there should be a way to do it using the LOOKUP functionality, but I've not managed to find anything that works.
Maybe LOOKUP() works better for you.
https://support.google.com/appsheet/answer/10107410?hl=en&sjid=13821535674502480582-EU
How would I reference the other app though? Is there some way of including the app ID in the 'reference' part of the syntax?
It is not contemplated.
Note that this expression is a Search in data expression, not search in applications.
If you have access to it, incorporate the Table where you are going to search for data into your application.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |