Sign Up ›
  • Michelle Littlefield 8
  • NEWBIE
  • 10 Points
  • Member since 2018
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 4
    Replies
SOLVED
8 replies

Formula with picklist options not working

I'm trying to create a formula for a custom field, where the picklist value of another field set it as a certain number. If the value is high, give the value 10, if Medium give 5, and if Low, 2. My formula is below. I keep getting various errors, this one in particular giving me the following error: "Error: Field Technology_Risk__c may not be used in this type of formula"

I'm new to formulas, do my formatting may be WAY off. Can anyone help?

IF( ISPICKVAL(Technology_Risk__c, "High") , "10" ,
IF( ISPICKVAL(Technology_Risk__c, "Medium") , "5" ,
IF( ISPICKVAL(Technology_Risk__c, "Low") , "2", null)))
SOLVED
8 replies

Formula with picklist options not working

I'm trying to create a formula for a custom field, where the picklist value of another field set it as a certain number. If the value is high, give the value 10, if Medium give 5, and if Low, 2. My formula is below. I keep getting various errors, this one in particular giving me the following error: "Error: Field Technology_Risk__c may not be used in this type of formula"

I'm new to formulas, do my formatting may be WAY off. Can anyone help?

IF( ISPICKVAL(Technology_Risk__c, "High") , "10" ,
IF( ISPICKVAL(Technology_Risk__c, "Medium") , "5" ,
IF( ISPICKVAL(Technology_Risk__c, "Low") , "2", null)))