I have a work sheet, and I am using data validation dropdown options to track the progress of the workflow. I have a certain section of that workflow that is only needed when the job is for a specific project. The data validation options are “Done” “In progress” and “Not started”. Is there a way to make it so that when, say for example, cell E 26 has the value of “FALSE”, the data validation dropdown options in the cells E10:E14 are automatically set as Done.
Example sheet will show how I have it set right now, and the “Result” sheet will show what I would like it to look like:
https://docs.google.com/spreadsheets/d/1Y_mbGtw4uDbCi0qWSfpmlwnhJ-Zo706bmetswj694gc/edit?usp=sharing

I tried using custom formulas, but they overwrite the dropdown options.