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?
