Is it possible to store a formula as text value?

[Igor-just-igor]

I have a table where each row should compute a final output in a very different manner according to one or two parameters. It's becoming unmanageable to have a gigantic IFS() function storing 5 ou 6 different formulas which already are somewhat extensive on their own.

I wish I could store the formula for each case separately as text and just create a simple short formula that says: "if case A, then fetch and execute as formula the text in SELECT(FormulaTable[Formula], [Cases]=A".

Could my dream come true? 😊

[AleksiAlkio · Accepted solution]

Unfortunately you can't read syntax for the formula dynamically.

[Igor-just-igor]

😢

could this be a feature in the future?

[AleksiAlkio]

Difficult to know, though it would be a good one.