Dropdown values based on other criteria chosen
Is there a way to only show certain values in the drop down column based on specific criteria in other columns?
For example, if the user chooses "Construction" as the department, only specific criteria based on that department will show up as options in the drop down of "Current Workflow Status". I need to keep this column the same for all departments for reporting.
Or do I need to just add all of the values in the "Current Workflow Status" for every department to see?
Answers
-
You would have to add them all for everyone to see regardless of selection if they are entering in the sheet.
If you use a form (or users don't mind extra columns), you can create separate columns for each of the departments and only list the applicable dropdown options that way. If using a form for entry, you can use form logic to only show the appropriate field based on the department selected. After setting up the individual columns, you can use a formula in your main [Current Workflow Status] column to pull in whichever of the individual columns is not blank.
