Conditional dropdown options
Is there a way to set up conditions for dropdown options in a sheet? For example, if I have someone filling out a form for a task list and they first select the task type, is there a way to only show certain options for the category based on the task type they select? If they select "instrumentation" for the task type in the form, is there a way to limit the options they can select for the category (e.g. only software, upgrade, or other)? I've attached images from the sheet I'm working on.
Help Article Resources
Check out the Formula Handbook template!