text to number

[sididesril]

I have a problem with the formula.

The case is: I have a table with 2 columns, namely the "input" column and the "result" column. The input column contains the text "4+5+9+8+1". I want the "result" column to show the results of adding these numbers. what is the formula

[Marc_Dillon · Accepted solution]

Appsheet does not have any sort of EVALUATE() function, so this sort of thing is not typically possible.

If you would only ever have addition in your text, you could try SUM(EXTRACTNUMBERS([text]))

[Marc_Dillon · Accepted solution]

Appsheet does not have any sort of EVALUATE() function, so this sort of thing is not typically possible.

If you would only ever have addition in your text, you could try SUM(EXTRACTNUMBERS([text]))

[sididesril · Accepted solution]

Thank you Marc...It's works

[Meyverick]

Any update about some sort of EVALUATE() expression? I'm desperately trying to do a similar things (DECIMAL(SUBSTITUTE([formula], "x", "1"))) 🙁