For example, I have two columns: one is ‘Is License Needed?’ and the second one is ‘License Type.’ Now, if the user selects ‘Yes’ from the dropdown in the ‘Is License Needed?’ column, the ‘License Type’ field will be displayed with the dropdown values ‘Professional’ and ‘Business.’ If the user selects ‘No,’ the ‘License Type’ field will not be visible.
In the next tab in that sheet, let the tab be named ‘Parameters.’ In this tab, you should include all the values and related dropdown values, similar to the ones in the above image.
Furthermore, in the form response sheet, the dropdown range for the ‘Is License Needed?’ column needs to be synchronized with the values in this sheet’s ‘Is License Needed?’ column.
Then, For the ‘License Type’ column in the form response sheet, you should add the following logic/formula: [conditional: 'Is License needed?', range: 'Parameters!A2:B', index: 2]
