Hi,
I'm building some workflow management (already in place, want to improve), and I'm unsure how to accomplish something. Here's the data I'm working with.
We have *PROCESSES* that are performed on *PARTS* which are done on *MACHINES*.
Multiple processes can be performed on the same part, some processes require multiple parts, and most parts can fit in multiple machines.
I've been using the "Valid IF" to create a three-tier dependent dropdown. I've got a spreadsheet with 3 columns called "pairings" that matches, processes to parts to machines. For example:
Sleeve Bearing > Shaft > Small Lathe
However, Valid IF enforces those pairings, where I would simply prefer them to be pre-selections. There are times when perhaps the shaft is larger, and we need it in a larger machine. Small Lathe might be the default, but I would like to be automatically selected, but "Large Lathe" to still be an option.
I've got a couple dozen of these process pairings done (3 items per - part, process, machine) and I'm hoping to fix this.
What would be the best way to do this? I don't want the hard enforcement of a "Valid IF" as much as preselection from my pairs of what the obvious machine/part/process combos are, with the ability to change the machine if needed, or the part if needed.
Is this possible?
LinkedIn
Twitter
