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?