How To Run a sheets function on a lookup result


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)


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?

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

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

1 Like