Forum Discussion

MichaelBarrow's avatar
MichaelBarrow
Qrew Cadet
8 years ago

Is there a way to test in a formula if a text field contains a valid number?

I have a complex text formula field that extracts out text from another text field. If it contains a number, I want to use it in another formula field's calculations. If not, I want to skip over it an...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
There may be other ways but this might be quick and dirty as a formula checkbox field.  But this will fail if the number has a leading zero like 0123.  If that is possible, then the formula will need to be a bit fancier.


ToText(ToNumber([maybe a number]))=[maybe a number]