Hello!

Is there a way to calculate the value of a mathematical expression which is written on a long text field?

For example (long text field: 3*40+8*50 and formula field: 520)

Hey @Dionisis_Priftis,

welcome to Airtable community.

You your case you have to extract the numerical info from long text fields and then use the exports in formula calculation.

I hoe my response helped you and for any deeper support please feel free to text at any time.

Yours sincerely,

Dimitris Goudis

@Dionisis_Priftis Airtable doesnâ€™t offer an â€śEvaluateâ€ť function like other programming languages do, so I donâ€™t think thereâ€™s any way that you could do that natively with an Airtable formula, unless all of your mathematical expressions are always going to look similar to that one â€” with a single known operator in between 2 values.

Although perhaps you could do something with Regex or a custom script.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.