0

In creating a formula to stamp the numerical value of a picklist, I am having difficulty with an "N/A" value. Right now, the picklist has 0,1,2,3,4,5,6,7,8,9,10,N/A as options to choose from. I am using the VALUE(TEXT(PICKLIST__c)) formula to get the numerical value in a number field. However, I am receiving an #Error! whenever the "N/A" value is chosen, as it is not a number.

Due to the fact that I need to rollup this numerical formula field, I need a way to treat the N/A as a null value. Can you assist? Thank you.

  • Nevermind, I believe I've solved my own issue with the formula: IF(CONTAINS(TEXT(PICKLIST__c), "N/A"), NULL, VALUE(TEXT(PICKLIST__c))) – Tamim J Oct 8 '15 at 21:03
  • You should probably either post that as the answer or delete your question. – Adrian Larson Oct 8 '15 at 21:30
0

Nevermind, I believe I've solved my own issue with the formula: IF(CONTAINS(TEXT(PICKLIST__c), "N/A"), NULL, VALUE(TEXT(PICKLIST__c)))

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.