I am planning on using data partitioning to be able to select different spreadsheets (from smartsheet) from an Enum list. What type of partitioning do I use, across many files/sources or across many worksheets? The spreadsheets will be constantly growing with different names but always the same structure. I am having problems using both so my first question is which one should I try and use?
There is no correct answer for your question… it depends. You can start to read more about it from this document… intercom.help - How should I use multiple sheets in my app? How should I use multiple sheets in my app? intercom.help
intercom.help
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |