Hi everyone,
We’re almost finished building our app for a judging event, but we’re running into an issue with sorting computed numeric values on our leaderboard.
Here’s our setup:
- Judges fill out a form that scores each team on several criteria (numeric values).
- Those criteria are totaled in a Math column (“Total Score”) for each team per judge.
- Another table uses a Rollup to collect all “Total Scores” for each team, and another Rollup to count how many entries there are.
- A Math column divides the total scores by the number of entries to get an average.
- An If-Then-Else column (“Average Total Safe”) replaces blank averages with 0, otherwise keeps the average value.
The “Average Total Safe” values correctly appear on our leaderboard table — however, Glide doesn’t recognize them as numbers, so we can’t sort by the average total. The only way to make sorting work is to manually copy those values into a separate Number column (or export and re-import), which isn’t feasible since this needs to update live during the event.
Has anyone found a way to make an If-Then-Else or Rollup/Math-derived column be recognized as a number for sorting in real time?
Thanks in advance!
