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.

2
  • 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, 2015 at 21:03
  • You should probably either post that as the answer or delete your question.
    – Adrian Larson
    Oct 8, 2015 at 21:30

1 Answer 1

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)))

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .