Sorting of new projects

[jscottsmith (Scott Smith)]

As you can see, we name our projects based on date+number+description. Generally, we set the board to sort names by most recent.

The default item name “New Project” shows up at the bottom of the list, so every time we create a new project we have to press the sort by project two times to see the new project come up. Is there any way around this? Perhaps changing the default name of new items?

Even better would be an automation that would calculate the next available project number and use that.

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Hi Scott,

You could create a formula using the Advanced Formula Booster, a 3rd-party app with unmatched calculation features. The formula would calculate the next number to be used based on the existing items. Then you would simply create an automation to run the formula when creating an item.

Demo:

 
Here is the formula’s syntax:

• The 1st line retrieves the list of all board item names, extracts the incrementing number and generates a new list made of all these numbers.
• The 2nd line calculates the highest number from that list and adds 1 to it to determine the Next number to be used.
• The 3rd line concatenates this number with “24-” and assigns it to the item’s name.

 
Once the formula created, all you need is one automation:

Hope it helps.