Hi Bryan,
Great question! Yes, it's possible, and creating a bunch of conditions would be a pain. Here's how you can sort a list of values, and then work backwards using a second list of names to figure out the order.
Video:
https://share.smartbuilder.com/public/support/sorting-values.mp4Sample file:
https://share.smartbuilder.com/public/support/sorting-values2.sb4Since we spoke last, we found out there's already a block that sort of handles this. Check out page 2 of file above. It requires formatting the data in a particular way - a List, and each entry in that List is a Map with two entries -
name and
count (those names are arbitrary, they could be
category and
score). With this method the logic is much simpler (one action block to sort), but the overhead of putting it in the right format and extracting the data that you need is higher.
List of Maps video:
https://share.smartbuilder.com/public/support/sorting-values-part2.mp4Let us know if you have any questions!