Pick Lists – Data Validation
Hello!
I want to be able to create a pick list which if chosen populates a number of columns with key information.
It’s for a recipe template I am doing so when I pick an ingredient, I want it to complete other columns about that ingredient – nutritional data, pricing etc
I can only seem to use Data Validation to fill in one column.
Can anyone help?
Hello!I want to be able to create a pick list which if chosen populates a number of columns with key information.It’s for a recipe template I am doing so when I pick an ingredient, I want it to complete other columns about that ingredient – nutritional data, pricing etcI can only seem to use Data Validation to fill in one column.Can anyone help? Read More