I have a google sheet setup. It contains an infinite amount of users. Each user has a set of data the is tied to them. ON the google sheet I can duplicate the template and from a dropdown box select a user and it will pull the data. How can I use this with appsheet, or do
I need to restructure my data?
If the data is not sensitive, you could use slice with the condition rule as [Email]=USEREMAIL(). If itโs sensitive, the security filter is needed with the same formula.
same โฆ
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |