Sort Choice values based on sequence

Pramod Pramod
Giga Guru

‎10-11-2023 12:28 AM - edited ‎10-11-2023 12:46 AM

We have a choice field on a table with below values in the sequential order:

  • Initiation
  • Peer Review
  • DRB Review
  • Implementation
  • Closed

I would like to sort them based on the sequence of these choices.

So If I sort ascending, it should show as:

  • Initiation
  • Peer Review
  • DRB Review
  • Implementation
  • Closed

If I sort descending, then it should show as:

  • Closed
  • Implementation
  • DRB Review
  • Peer Review
  • Initiation

Users would be sorting from list view on the table like below:

PramodPramod_0-1697010313044.png

Note: We cannot update the value of the fields as it is already in production.

Any help is appreciated.

 

 

 

Regards,

Pramod

Preview file
23 KB
0 Helpfuls
  • 418 Views
2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

‎10-11-2023 12:42 AM

@Pramod Pramod 

where are you planning to add the sort? how will user sort?

share screenshots.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
0 Helpfuls

Pramod Pramod
Giga Guru
In response to Ankur Bawiskar

‎10-11-2023 12:47 AM

Hello Ankur,

Users would sort in the list view of the table. I have added screenshot to the post.

 

Regards,

Pramod

0 Helpfuls