Starting November 20, the site will be set to read-only.
On December 4, 2023,
Apex Code Development (90768)
General Development (55146)
Visualforce Development (37251)
Lightning (18265)
APIs and Integration (17146)
Trailhead (11680)
Formulas & Validation Rules Discussion (11337)
Other Salesforce Applications (8116)
Jobs Board (6655)
Force.com Sites & Site.com (4842)
Mobile (2694)
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!