Skip to Content

Dropdown assignment to another dropdown

Hello

I have a requirement , I have create a dropdown1 and assign a property of the costcentre dimension. Also I have another dropdown 2 which has items 'yes' and 'no' , if the user selects yes I want the dropdown 1 to list out the values, if its no then the dropdown 1 should not be active.

thanks !!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 10 at 08:54 AM

    Screenshot with full details, please!

    How do you created dropdown?

    Add comment
    10|10000 characters needed characters exceeded

    • Attached is the screen shot, If I use Dropdown A it will give me 'Yes' and 'No' values and if the user chooses Yes then dropdown B will be active user can have the drilldown costcentres ( coming from Costcentre dimension ).
      cost-centre.png (2.3 kB)
  • Jan 10 at 09:13 AM

    P.S. "dropdown 1 should not be active" you can't disable dropdown using Excel formulas, maximum you can do is the empty dropdown!

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 10 at 09:54 AM

    The only thing you can do is to replace values in the list column with empty strings:

    Other things will require VBA coding.

    Add comment
    10|10000 characters needed characters exceeded