You need to sign in to do that
Don't have an account?
chiranth
Picklist vale based on the formula field .
I have a picklist field called Type with the values 1,2,3,4,5,6,7,8,9,10.
I have one formula field calles status.
I need to display values 1,2,3,4 in Type Picklist field when status is open.
I need to display values 5,6,7,8 in Type Picklist field when status is closed.
I need to display values 9,10 in Type Picklist field when status is Re Opened.
Status is a formula field.
By using formula field, we cannot change the picklist value. The best way is to use two picklist fields:
Status:
Open, Closed, Opened.
Type:
1,2,3,4,5,6,7,8,9,10.
Goto> Field Dependencies and make Status as Controlling field and Type as Dependent field.
Madhan Raja M
All Answers
By using formula field, we cannot change the picklist value. The best way is to use two picklist fields:
Status:
Open, Closed, Opened.
Type:
1,2,3,4,5,6,7,8,9,10.
Goto> Field Dependencies and make Status as Controlling field and Type as Dependent field.
Madhan Raja M
No, we cannot make the formula field as a Controlling field.
Madhan Raja M