Sorting Groups Separately

Someone else posted a thread for this but it was closed with no response from Monday

We desperately need to be able to sort by group - creating separate views does not work for us as we need all the information on one page.

One group we want to keep in order of Creation Date
One group we need to be able to sort by Closing Date (well ideally Timeline end date but that’s another missing feature).

Could anyone please let me know if this is something being considered at all?

@TaylorTedesco

I don’t know if sorting differently by groups is being considered for development. But, if your workflow will allow you to set a value on your board to the group it’s in, you could add a formula column with a formula like this:

SWITCH({Group},"Group1",{Creation Log#Date},{Timeline#End})

In this example, {Group} is a status column that matches the group the item is in. The formula returns the creation date when the item is in Group1 and Timeline#End otherwise. Sorting by this column would then do what you want.

Setting the initial {Group} status column to the group an item is created in is the tricky part. This could be done with Integroomat. One example of how to do it without the use of a custom app/Integromat would be:

  1. Tell users to only add items to Group1
  2. Set the default for {Group} status column to “Group1”
  3. Add this automation for each group on your board:

Jim - The Monday Man channel
Signup for a FREE Integromat account with this link and get a FREE hour with The Monday Man