+ Start a Discussion
rornelasrornelas 

Need a formula field to check if string contains numeric value

Hi Everyone,

I need a way determine if the accountNumber field contains -1. I got it work when -1 is the only value in the account number field. The formula needs to identify identify wether -1 is present the string (i.e. 11706-1). Not sure what else I need to do here.
 
IF(  CONTAINS("-1", Site) , BillingCity , 
IF(   NOT( CONTAINS("-1", Site) ), ShippingCity , 
IF(  CONTAINS("", Site)  , ShippingCity , BillingCity) ) )

 
Best Answer chosen by rornelas
LBKLBK
You have passed the parameters wrong to the CONTAINS function.

Is your requirement such that if -1 exists it is BillingCity otherwise ShippingCity?

If yes, try the formula below.
IF(  CONTAINS(Site, "-1") , BillingCity , ShippingCity)
Let me know if this helps.

 

All Answers

LBKLBK
You have passed the parameters wrong to the CONTAINS function.

Is your requirement such that if -1 exists it is BillingCity otherwise ShippingCity?

If yes, try the formula below.
IF(  CONTAINS(Site, "-1") , BillingCity , ShippingCity)
Let me know if this helps.

 
This was selected as the best answer
Miledccs SmithMiledccs Smith
Thank you so much for this. I was into this issue and tired to  tinker around to check if its possible but couldnt get it done. Now that i have seen the way you did it, thanks guys
with
regards

https://plex.software  (https://plex.softwarehttps://kodi.software/ https://luckypatcher.pro/