I want to avoid using text to number as it get 1 update, my users would be a lot, therefore I did math text to number, I got an array on number still in text and try to use math to get to numbers, but when I get to the value replacement, I could not find the array name colum. Please can anyone help, I need it ASAP
What do you mean by “math text to number”? If you have an array as the result, I think you must convert it to a string by a joined list column first.
Can you write your number to a number-type column and text to a text-type column?