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.
Whoa that worked. Just edited and saved without changing anything…
What manner of voodoo haha… Anyways thanks Darren!
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.
2 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.