Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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.software) https://kodi.software/ https://luckypatcher.pro/
Rahul Kumar 767Rahul Kumar 767
Thanks for sharing valuable content. Such a nice post. Also, visit Kalia Yojana (https://pradhanmantri.info/kalia-yojana-list-odisha).