Right( ) cannot successfully work.

[T-Shigenori]

I have 2 tables and also I set the usersetting(language)  and can choose English or Japanese.

When I choose one of these languages, column name , VC, enum, enumlist are automatically translate English or Japanese by setting switch() formula.

In case of enum,  the value I set are English word and Japanese one.

see below table 1( 患者追跡table). 

And at the other table, I set the VC formulating select(患者追跡[搬送ステータス],
[認番ID]=[_thisrow].[ID].

and then, I set the the another VC formulating RIGHT(text([搬送ステータス]),4).

When I selected Japanese at the usersettings, the above right()formula can work.

However when I selected English, the above right()formula cannot work successfully.

As you can see the last image, "Done" cannot be returned.

Does anyone know why this situation happen?

Or could you tell me how to solve the problem?

[TeeSee1 · Accepted solution]

Even though I suspect there might be a better way to implement your requirement, you can try the following without changing what you have configured so far.

Since [搬送ステータス] is a list, if you want to get the "last element" you can try

INDEX(
 [搬送ステータス],
 COUNT(
  [搬送ステータス]
 )
)

 as the App Formula of [配送の状況].

[T-Shigenori]

Thank you very much!!