I'm still in early stages. I have an excel sh...

(Paul Dionne) #1

I’m still in early stages. I have an excel sheet that generates calculations on one sheet based on profile on another sheet. It also has a look up to assign the calculations a ‘score’ for the person’s achievements. The problem is the way it is now (using lookups) I can only have one profile per calculations worksheet.

A second idea I have would be to use code (case select) and pass back the results for multiple profiles.

I see that google sheets can trigger code in zaps, but can the output of the code be passed back to google sheets?

(Bellave Jayaram) #2

We don’t use Zapier much but if not doable by Zapier, it can be done by using scripting (and we have done this in many instances).