Sign Up ›
  • Dikla Tenenboim
  • NEWBIE
  • 10 Points
  • Member since 2016
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 1
    Replies
1 replies

Creating a Formula Field

Hello,

i'm tring to create a new formula field, based on 2 picklists.
I wrote down the following formula and i got a syntax error:

IF(AND( ISPICKVAL(Color__c ="red"),ISPICKVAL( Car_Category__c ="mini")),1, IF(AND( ISPICKVAL(Color__c ="blue"), ISPICKVAL(Car_Category__c ="manager"),2), IF (AND( ISPICKVAL(Color__c ="yellow"),ISPICKVAL( Car_Category__c ="premium"),40),null))

I need your assistence 
Thanks
Dikla
SOLVED
4 replies

Unavailable value in picklist

Hi,
I have a picklist with 5 values and i want to turn one of them to unavailable (imposible to choose) for all users
how can i do it?

Thanks
SOLVED
4 replies

Unavailable value in picklist

Hi,
I have a picklist with 5 values and i want to turn one of them to unavailable (imposible to choose) for all users
how can i do it?

Thanks