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
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]))
Thank you Marc…It’s works
Any update about some sort of EVALUATE() expression? I’m desperately trying to do a similar things (DECIMAL(SUBSTITUTE([formula], “x”, “1”))) 