Help

Re: Chart displaying order incorrectly, or at least not the way I'd expect

Solved
Jump to Solution
931 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Sean_Lake1
8 - Airtable Astronomer
8 - Airtable Astronomer

image
Greetings!
I’d created a formula:
CONCATENATE({Month #},“-”,Month)
so that grouping in my table(s) would do so since obviously April would be first in the order, etc. However, when I have it sorted in the chart, as you see, the order is, well, not what I’d expect.
Any suggestions?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

It’s alphabetizing those segments, so you would need to put a leading zero before the Month #.

So, for the Month portion of your formula, change it to this:

RIGHT("0" & {Month #},2)

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

It’s alphabetizing those segments, so you would need to put a leading zero before the Month #.

So, for the Month portion of your formula, change it to this:

RIGHT("0" & {Month #},2)

Sean_Lake1
8 - Airtable Astronomer
8 - Airtable Astronomer

OMG, thank you. DOH! Appreciate the insight.