How To Allign A correct Monthly Order?(like jan,feb,mar....)

[BHUVANESH]

How to Allign A correct Month order In char view? 

I have Column Month..

  Value Is See Image(april,aug,feb...)

But In Chart view I want Correct order...

Please Any one Help Me....

Thanks For Advance

[Thales_Taranto · Accepted solution]

The way i think you should do is to create a VC to associate the month to it's number. I would use SWITCH function:

https://support.google.com/appsheet/answer/10107700?hl=en

SWITCH(

[Month],

"January", 1,

"February",2,

"March",3,

"April",4,

...(you know what i mean)

)

Now you have a column to ordinate, now you have to search how to order it on the chart view.  

[Thales_Taranto · Accepted solution]

The way i think you should do is to create a VC to associate the month to it's number. I would use SWITCH function:

https://support.google.com/appsheet/answer/10107700?hl=en

SWITCH(

[Month],

"January", 1,

"February",2,

"March",3,

"April",4,

...(you know what i mean)

)

Now you have a column to ordinate, now you have to search how to order it on the chart view.  

[BHUVANESH]

Oh yes  . I make Small Change...Its Working..

CONCATENATE(
  MONTH([invoice_date]),
  "-",
  SWITCH(
    MONTH([invoice_date]),
    1, “January”,
    2, “February”,
    3, “March”,
    4, “April”,
    5, “May”,
    6, “June”,
    7, “July”,
    8, “August”,
    9, “September”,
    10, “October”,
    11, “November”,
    12, “December”,
    “”
  )
)

[Suvrutt_Gurjar · Accepted solution]

An alternative and equivalent smaller expression could be 

CONCATENATE(
  MONTH([invoice_date]),
  "-",
  TEXT([invoice_date], "MMMM")
  )

TEXT() - AppSheet Help

Edit: Still smaller would be

TEXT([invoice_date], "M-MMMM")