Alphabetically ordered list

Hello all,

I have a list of employees without alphabetical order in my model.

On the dashboard, I can create a new employee in the list but I want the whole list to become ordered alphabetically when displaying for example. Would it be possible to help me ?

Regards,

Accepted answers

All comments

Kanishq17

Hi @soukainawaraki

You can create line item referring name of the employee and then sort based on that line item using sort ascending and then publish that to dashboard,

when you will add a new employee and refresh , it will automatically be added based on sorted position

This is my module in the db,

Now added a new employee named Eva

It got sorted to the required position

anirudh

Hi,

Try this setting

And in the resultant popup click on Ascending and hit OK

That should work

Regards,

Anirudh

soukainawaraki

Thank you for your answer.

Very good tip. I manage to apply it to a module and it works. But, is there a way to apply this order on the list itself ?

So that the order will be applied in all modules that contain the Employee list?

Thank you !

anirudh

Unfortunately no! You will have to repeat this process for each module
Lists them have to be manually reordered...

MaryM

There is a new feature: Order List action

https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Order-list.html?_ga=2.136222710.635220381.1601650289-1152843459.1599592837

Steps that have worked for me:

1. create a new module based on the list you want to sort

2. Create a line item with a formula that creates the value you want to use for sort (Ex: Last Name, First Name combination)

3. Create a SORT line item - Text format - NO FORMULA

this line item will be the one referenced in the action

4. Either manually copy the values from item in (2) above and paste into item in (3) or create an action to do this

5. Create and run the action using values in (3) for the sort

It appears you cannot use an item with a formula that references your list as the item to sort by. Therefore you need a non-formula based item to sort with.

Hope this helps!

DavidSmith

@MaryM

Could you elaborate on "It appears you cannot use an item with a formula that references your list as the item to sort by. Therefore you need a non-formula based item to sort with."

As long as the line item is formatted as Text or numeric, you can use a formulaic line item e.g. NAME(ITEM(Listname))

David

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385