Hello AppSheet
I have two spreadsheets, both with key columns. They have a parent-child relationship. The “key” column in the clipboard spreadsheet becomes a value in the “order” column in the delineatedLocations spreadsheet. All rows with the same value in the “order” column in the delineatedLocations spreadsheet correspond to each other in a group within the clipboard spreadsheet.
I’m trying to write a SELECT() statement that groups the rows according to whether or not they have the same value in the “order” column. Something like
SELECT(delineatedLocations[key],value in order
column=value in key column in clipboards table)
How do I go about this?
Thank you.
Tiffany
User | Count |
---|---|
35 | |
31 | |
30 | |
19 | |
17 |