Hi, I created a very simple app to help with our invoicing.
I set the collection to sort by balance owed in decreasing order
But the sort is pretty bonkers as shown.
Any ideas why?
Ya that $9900 is wrong. Where does this data live? Glide table? Google sheets?
Thanks for your reply Robert. Yeah it’s not just the 9900 but even more as below. And think I figured it out now…
The balance owed column was a number formatted as currency in the Google sheet.
Glide claims to read it in as a number but apparently still treats it as a string for sorting purposes.
When I created a duplicate column in Sheets formatted as purely a number to sort on, it works fine now:
So is this a Glide bug?
Try editing the column type in Glide and save it again.
Yeah, that happens a lot with Google Sheets. It’s good practice whenever you add a Google Sheet to go through all the columns one by one and set the column type.