I’m organising my feedback data (from Airtable), and I’m grouping it by rating, then sorting based on rating 1-5. I would also like to add another sort within the group to show the most recent answers first. As you can see from my example, within the group, the dates are random. Is that possible?
What you could do is convert your date to an integer and combine it with your rating using a math column, and then use that column for the sort. The math formula would be something like:
Rating * 100000000
+ Year(Date) * 10000
+ Month(Date) * 100
+ Day(Date)
So for example, if you had a rating of 5 with todays date, you’d get 520230103
A rating of 5 with yesterdays date would result in 520230102
So your list would sort naturally first by rating, and then by date.
Here’s what that would look like in the Data Editor…
1 Like