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.
Jul 14, 2019 01:08 PM
Am I doing something wrong here? For decimal values inside a string, “0.5 some text” or “12.1 some text”, when I use, Value(left(0.5),4), I do not receive the decimal value. It will return the first integer of number. Is there a different want to return the decimal number found on the left most side of the string as mentioned above?
J
Jul 15, 2019 04:16 AM
Hi @Jason_Calaiaro - your formula works fine for me:
Combo field is:
VALUE(LEFT(Name, 4))
Make sure the formatting on the field is set to decimal
JB