Apex Code Development (89877)
General Development (54729)
Visualforce Development (37149)
Lightning (17586)
APIs and Integration (16775)
Trailhead (11582)
Formulas & Validation Rules Discussion (11173)
Other Salesforce Applications (8010)
Jobs Board (6637)
Force.com Sites & Site.com (4797)
Mobile (2662)
You need to sign in to do that
Don't have an account?
Adrian-E I have a picklist on a parent field with dropdown options from 1 through 50.
I want to have a formula on the child account which copies the same selection from the parent.
I have tried combinations of CASE, ISPICKLIST, OR and evrey other option to no avail.
Any suggestions?
No magic bullet on this one. Getting the vales from a Picklist to a text formula is a tedious, inefficient process. Vote for Please get this Done Soon although it has been an issue for a long, long time. And it can be a maintenance nightmare if your picklist values change.
I think your formula would need to be a CASE with 1 through 50 repeated.
CASE( Parent.picklist_field_name , "1","1", "2","2", all the way to 50
All Answers
No magic bullet on this one. Getting the vales from a Picklist to a text formula is a tedious, inefficient process. Vote for Please get this Done Soon although it has been an issue for a long, long time. And it can be a maintenance nightmare if your picklist values change.
I think your formula would need to be a CASE with 1 through 50 repeated.
CASE( Parent.picklist_field_name , "1","1", "2","2", all the way to 50
Worked like a charm!Thanks a million!
I've also voted for the idea posted above and will urge my colleagues to add their votes their too.
Once again, thanks!