I have the following tables and relevant columns in Appsheet.
You can't really do that. Or rather, I don't recommend it in the face of a much easier solution:
Add a new column to the WDE table that references the WPE table (or change [Exercise Name] to be that). You can use ORDERBY in the valid_if of this column, ordered by the number.
Try:
ORDERBY(
FILTER("Exercies",
IN([_ThisRow].[Workout Plan],
[Related Workout Plan Exercises][Workout Plan]
)
),
ANY([Related Workout Plan Exercises][Exercise No]), FALSE,
[Exercise Name]
)
User | Count |
---|---|
25 | |
25 | |
25 | |
23 | |
16 |