How To Run a sheets function on a lookup result

Ask for Help
1

Hello,

I have a lookup result in glide.
I want to create a new column(for display in the app) where each cell is the result of a sheets function with the lookup result as parameter. I mean :

cell = sheetsFunction(lookupResult)

possible?

2

Do you have that lookup result in your sheets? You have to have it there to be able to apply sheet functions. Can you describe more about your use case?

3

I don’t.
That’s why I’m asking a question here.
I have a function in sheets which converts time zones.
I wanted to use it

4

Then you have to make a VLOOKUP function yourself in the sheet to be able to use Sheets functions with it.

1 Like