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?
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).
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |