Extract numerical values to find total sum from string

I am new and teaching myself databases and AirTable so please be gentle. :smiley:

I am trying to extract the numbers from the {Recipe} column and add them all together to figure out the total number of drops for each blend. Is it possible to do this with my current setup? I have figured out how to extract the numbers but it just smooshes the numbers to become a 2-6+ digit number.

I hope this makes sense.

Yes, use Value() to parse the floats. And welcome to the community!

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