title: How do you do dynamic / dependent drop downs in Google Sheets?
body: <p>How do you get a sub-category column to populate a drop down based on the value selected in the main category drop down in google sheets?</p>
  
  <p>I googled around and couldn't find any good solutions, therefore I wanted to share my own. Please see my answer below.</p>