Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Extract numerical values to find total sum from string

Topic Labels: Formulas
1004 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Monica_Spaunho1
4 - Data Explorer
4 - Data Explorer

Screenshot 2021-05-30 183756

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

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.

1 Reply 1
Dominik_Bosnjak
10 - Mercury
10 - Mercury

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