Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Calculate mathematical expression in text form

Topic Labels: Formulas
232 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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: 340+850 and formula field: 520)

2 Replies 2

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.