Hi folks,
I’m trying to find a numerical value from the “Title” field and have it appear in the “amount” (e.g. 27.21)
I’ve used this formula from looking at a few post’s but it only copies the values before the decimal:
MID(
{Title},
FIND(
“For”,
{Title}
)
- 6, 50
)
Another formula I found only copies the values before the decimal:
IF({Title}, VALUE(RIGHT({Title}, LEN({Title})- FIND(“0”,“1”,“2”,“3”,“4”,“5”,“6”,“7”,“8”,“9”, {Title}))), 0)
What formula do I need to get the full total which in this example is 27.21?
Thanks in advance!
:winking_face:
