Hi,
I’m working with my deals in a list view.
I want to sort these records in a specific way:
sort by company name first AND then sort by deal stage maintaining the first sort criteria. how can I achieve this?
What is happening right now:
I sort by company name, when I sort by deal stage the company name column gets messed up.
Many thanks for your help!!!
Hello @Edyta7510, thank you for providing a screenshot of what is happening on your end, I would like to invite our top experts @Jonno_Price @Josh @LouiseGlover any recommendations to @Edyta7510 matter?
Hi @Edyta7510
The ability to sort alphabetically in list view is limited to a single property, unlike say an excel spreadsheet where you can combine sorting on multiple columns.. What could be better for you is to create and save views.
E.g. set the columns you want to see, sort companies alphabetically and then apply a filter for a deal stage. Then save that as a view. Filter by the next deal stage and save that as a new view… and so on. You will now have saved views for each deal stage that you can click through that shows all companies alphabetically.
Hope that helps.
Thanks @Jonno_Price
I thought indeed that sorting is limited to 1 property at a time, you’ve just confirmed.
I’ll indeed play with multiple views as you suggested.
Thanks
Hello Jonno, tagging on to this old thread with a question. When we are in list view for Deals, we do not have the option to sort by Company Name at all. Every other column can be sorted alphabetically/numerically. Why is that and is there a setting we can chnage to get this to work. Screen shot shows no sort function for that column…
Hi @JuiceMcNally
The reason is the Company Name that you are seeing in that column isn’t actually a deal property. It is the associated Company record - and unfortunately this means it is not available to sort by. One thing we usually have in place is that every deal in the pipeline is prefixed by the company name. Deal Name is a deal property and so assuming you have the same and each deal starts with the company name, then you should be able to sort by the deal name property, with the same end result.
If for some reason your deals don’t start with the company name then you have one other option - create a custom Deal Property (e.g. Deal - Company Name) and then have a workflow which copies the name from the primary company associated to the deal to this deal property. You’ll now have a deal property that should be sortable in the view layout.
Hope that helps!
Thank you. This is dissappointing to read but I understand the limitations. If all our delas are tied to a company, I do not see why we can’t sort by that already. I will review with my team and see which option you proposed will work best for us.
I would also like to see “Advanced Sort” function added for list view. This is one of the basic attributes of any database and would be a great new feature.
Hi @Hutchlyn,
Thank you for feedback.
I would highly recommend you to please post this product suggestion at our ideas forum.
Our product team, who monitors the forum regularly, can read your specific use case and understand why this would be a useful functionality or change. It also helps other customers facing the same issue to advocate for its implementation on your behalf by upvoting on the thread as well.
Thank you,
Kristen