datavalidationsample.ods (7.8 KB)
How do I use data validation to allow or block user input based on the cells to the left. I just want to stop data being placed in the wrong column.
I thought I could use a custom formula that evaluates a condition being true or false and if true allow user input.
In the example apples and oranges are always purchased at the market price and should only be allowed in the market column.
I thought I could use something simple like IF(B2=“Apples”) allow user input in the market column and a NOT function in the wholesale column but its always invalid.
Any help is appreciated