In a column, I have a select_one function from a choices list of 45 string values. I am trying to populate a cell with an integer value based on this first choice. from a second choices list.
The first Choice list looks like this;
|Lot||Acadia Street West (6)||Acadia Street West (6) - 12|
The second choice list looks like this;
|Lotn||Acadia Street West (6) - 12|
I can build out a series of If statements (45 in Total), but just wondering if I can populate the second field with an integer from the second choice, based on what I chose from the first Choice List.
Hope this makes sense.