Option to break out of groups when sorting / or filter to see a whole column

i have a list of 16 groups, each group is a stage of our process for example:

  • Need to send invoice
  • Waiting for payment
  • need to send reciept
  • ready to do
  • completed

A bit like that but 16 steps of our process. Each group has customers in it with all of their information set out in columns. we can have anywhere between 80-100 customers on the board at any one time.
The customer can then easily be moved into its group depending on where they are in the process and its a nice way of quickly seeing where each customer is at in the process.

One of the columns is the customer invoice number.

Ideally, when we get a new customer we could do with knowing which invoice number we are up to. So if the last invoice number was 100, we know a new customerā€™s invoice number will be 101.

But when we click ā€˜sortā€™ via the ā€˜invoice numberā€™ column it will keep the customers within their group and as a result the highest ā€œoverallā€ number isnā€™t shown at the top, but rather each group is sorted individually. so we still donā€™t really have a clear way of know what the highest invoice number currently is.

Either being able to filter the information somehow (canā€™t filter just a whole column) or if the sort button had an option to ā€œbreakā€ the groups and sort all customers.

Maybe someone has an easier way or better idea to easily find the highest number in a column which is spread across multiple groups?

As far as I can see this is a good fit for an Integromat based automation:

  • trigger a webhook on item creation

  • in Integromat loop through all items in your board and find max

  • or (less operations needed) update an Integromat database value (persistent over different events) with +1 and return that value to your column

Have fun

oh wow, i wish knew what any of that meant! :joy:

even after some googling, i think that might be too much for my little brain

+1

This is an important option, both for boards and for table applet in the dashboards.
we have different groups in boards that are separated by various keys (global region, Inventory type, etc.) and we want to sort the view by due dates or priority and see all the High priority items without the separation by groups

2 Likes

hi @aperegrine, Adam

I have a monday app that generates an ID which will increment automatically when an item is added to a board. In this way you donā€™t have to search for the highest number. The configuration is:


You can easily create an ID like INV-0001, the next will be automatically set to INV-0002 etc etc
Does that help you?

I have this same use case, itā€™s annoying you canā€™t sort across groups, or just visually turn off ā€˜groupingā€™ for a specific view. Two years later and still no solution.

4 Likes

I have team members asking for this too. Weā€™re using groups for agile iterations but some want to be be able to see an ungrouped list of all items sorted by date.

2 Likes

same issue in our company
Itā€™s really annoing to be forced in the grouped view of all contents.

This would be helpful. In our use case, I would like to filter all tasks that are behind schedule and cut and paste them into a slide. In this instance the groups are not necessary and the information is too separate to be visually helpful.