Need Formula Assistance

[LEX_STUDIO]

I want to be convert a list of Enumlist of text into Enumlist of numbers.

Eg. (Jan, Feb, Mar, April) into (1, 2, 3, 4) etc.

However, i want it automated so once you create the Enumlist it will fill a field with the same list but in a form of numbers following the index list of the Enumlist.

The number list must count whenever there is a comma(,) in the list.

@Steve 

@

 MultiTech 

[Fael]

Give it a shoot:

SPLIT(LEFT("1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100",
(COUNT([Original EnumList])*2)-1), ", ")

Unfortunately, since AppSheet does not have a loop formula, you must limit the number of possible selections. In this case, I limited it to 100, so it will only work up to 100 EnumList entries.

However, it is possible to make a loop action, but the action would take some time to calculate, not an instant response.

Take a look at:

SPLIT() - AppSheet Help 

LEFT() - AppSheet Help 

COUNT() - AppSheet Help 

[Marc_Dillon]

I'd recommend created a month table, with at least 2 columns: month and month_number. Then you can set your enumlist to be a ref to this table, and you can list-dereference the numbers out.

https://help.appsheet.com/en/articles/4575708-list-dereference