+ Start a Discussion
cldavecldave 

formula field to input a specific data if picklist value =x

Hi

 

Need to create a formula field , that if Status = --Not Started-- to put the number 1 in that field

 

Here's what i got so far, but it seems i have a syntax error somewhere

 

ISPICKVAL(Status, "--Not Started--")0,1

 

 

can anyone pls help me?

 

 

Thx in advance

Best Answer chosen by Admin (Salesforce Developers) 
Jeff TalbotJeff Talbot

The basic IF statement syntax is:

IF(

       logical_test,

       value_if_true,

       value_if_false

     )

 

 

IF(

       ISPICKVAL(Status, "--Not Started--"),

       0,

       1

    )

All Answers

Jeff TalbotJeff Talbot

The basic IF statement syntax is:

IF(

       logical_test,

       value_if_true,

       value_if_false

     )

 

 

IF(

       ISPICKVAL(Status, "--Not Started--"),

       0,

       1

    )

This was selected as the best answer
cldavecldave
Thank you!