Hi,
I am wondering whether it is possible to have a drop down list based on the value of another cell. I have already created dependent drop-down lists, but now I am facing more of a "if this cell has this value, create this drop down list, otherwise don't let the user enter a value".
Here are the lists we can work with for this example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Foods[/TD]
[TD]Fruits[/TD]
[TD]Vegetables[/TD]
[TD]Nuts[/TD]
[TD]GoodBad[/TD]
[/TR]
[TR]
[TD]Fruits[/TD]
[TD]Apple[/TD]
[TD]Carrot[/TD]
[TD]Cashews[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Vegetables[/TD]
[TD]Banana[/TD]
[TD]Corn[/TD]
[TD]Almonds[/TD]
[TD]Bad[/TD]
[/TR]
[TR]
[TD]Nuts[/TD]
[TD]Kiwi[/TD]
[TD]Kale[/TD]
[TD]Peanuts[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
In in column A is found the Foods list (either fruits, veggies or nuts), and let's say we select Fruits. The drop down list in column B will then be either Apple, Banana or Kiwi. I have that covered!
My question is, let's say that ONLY for Fruits, I want the column C to have the "GoodBad" drop-down list - but only if column A has "Fruits" - otherwise I don't want the user to be able to enter any values (the sheet will be locked in the end, if this detail helps). Is this possible?
Thanks for your help!
I am wondering whether it is possible to have a drop down list based on the value of another cell. I have already created dependent drop-down lists, but now I am facing more of a "if this cell has this value, create this drop down list, otherwise don't let the user enter a value".
Here are the lists we can work with for this example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Foods[/TD]
[TD]Fruits[/TD]
[TD]Vegetables[/TD]
[TD]Nuts[/TD]
[TD]GoodBad[/TD]
[/TR]
[TR]
[TD]Fruits[/TD]
[TD]Apple[/TD]
[TD]Carrot[/TD]
[TD]Cashews[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]Vegetables[/TD]
[TD]Banana[/TD]
[TD]Corn[/TD]
[TD]Almonds[/TD]
[TD]Bad[/TD]
[/TR]
[TR]
[TD]Nuts[/TD]
[TD]Kiwi[/TD]
[TD]Kale[/TD]
[TD]Peanuts[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
In in column A is found the Foods list (either fruits, veggies or nuts), and let's say we select Fruits. The drop down list in column B will then be either Apple, Banana or Kiwi. I have that covered!
My question is, let's say that ONLY for Fruits, I want the column C to have the "GoodBad" drop-down list - but only if column A has "Fruits" - otherwise I don't want the user to be able to enter any values (the sheet will be locked in the end, if this detail helps). Is this possible?
Thanks for your help!