Filter/Limit Drop Down Values

Ramsay Zaki
Ramsay Zaki ✭✭✭✭✭✭

Is there any way to limit the values that appear in a Drop Down based upon the current value selected? For example, we want our Statuses to follow a specific progression (e.g. New --> In Progress --> Deploy --> Closed). If the currently selected Status is "In Progress" they should only see '"Deploy" in the drop down (not New or Closed).

Is there any way to do this (within the sheet itself, Dynamic View or anywhere else)?

Sorry if this has been asked before... did a search but didn't find a question exactly like this.