I was wondering if someone could help me with an issue I'm having in SharePoint. I made a library and one of the columns has a Yes/No option. The following column is based on that response. If the answer is Yes I have a drop down with 3 different options, however if the answer is No there is only one option it could be. Is it possible to have the column auto-populate is someone selects the No option?