I have a gallery and I am sorting it by a column called "Amount".
The problem is it is treating "Amount" as text rather than a value. So all of my values starting with 9 come first then, 8, 7,6.
I need to sort by value, so that the largest amount comes first. Any ideas?
Hi @Anonymous
Change your SortByColumns to just Sort, remove the double quotes from amount and make it amount*1. That will convert amount from a text to a number. I like to use *1 instead of wrapping it with Value(), it's a more concise way of doing the conversion. and easier to follow in long formulas.
Share
Report
All responses (
Answers (
432
