How to select option in dropdown based on selected option in another dropdown field?

Hi,

I need a help!

kindly check the attached screenshot and let me know the valid solution of my following problem.

Problem: if i select "Program Director" then by default values should be appear on the 2 drop downs which should be "School of Arts, Humanities & Social Sciences" and "Communication & Design"

NOTE: i don't want to add more drop downs in my form because that will create an empty column in my excel sheet.

so I just want some conditions to be performed in the same drop downs.

Kindly guide me the solutions as soon as possible.

Thanks,

Zehra

Kindly send me the form link on which you have performed
Zehra Batool
IT Applications Officer
Habib University
...

Could you please tell me that where is this Select option on calculation ?
Zehra Batool
IT Applications Officer
Habib University
...

In calculation field’s value, how you have write Select A?
Zehra Batool
IT Applications Officer
Habib University
...

Could you please tell me that where is this Select option in the calculation?

For example in this drop-down:

The condition is:

So 'select A' will be selected in the second drop-down when 'select 1' is selected in the first dropdown.

In calculation field’s value, how you have to write Select A?

You simply write it:

Let us know if you need any further assistance.

Thank you!