Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Fixing Lead Sorting Issues: Why 100-Score Leads Rank Last

·

·

I rank my leads and then sort from Z to A with the text only column of the ranking... but for some reason the leads that score 100, are always put at the very bottom of the list. Any idea why or how I can fix this?

Loading attachments

Fixing Lead Sorting Issues: Why 100-Score Leads Rank Last | Clay

6 comments

· Sorted by Oldest

Ryan Hashemi
·
·
link to table: https://app.clay.com/workspaces/316110/tables/t_xZrDe6ECC4Vo/views/gv_2Eh2DakfVJUm
Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Jialiang Zhou
·
·
Hey, just a community member here. The reason why 100 is lowest because it's sorting the values as strings. I think you can create a new "number" column, click edit column, use regular expression to filter out the numeric value and then sort
🙏1
Ryan Hashemi
·
·
aha! i will give that a try. thanks Jialiang Zhou
Ryan Hashemi
·
·
worked, you're the man
1
Channeled
APP
·
·
Hi Ryan Hashemi! This thread was recently closed by our Support team. If you have a moment, please share your feedback: