You need to sign in to do that
Don't have an account?
cldave
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
The basic IF statement syntax is:
IF(
logical_test,
value_if_true,
value_if_false
)
IF(
ISPICKVAL(Status, "--Not Started--"),
0,
1
)
All Answers
The basic IF statement syntax is:
IF(
logical_test,
value_if_true,
value_if_false
)
IF(
ISPICKVAL(Status, "--Not Started--"),
0,
1
)