User selects a cell for dropdown. Dropdown shows A,B,C,D,E,F. Upon rollover of B, a new 2nd dropdown populates with RED, BLUE, GREEN, PURPLE. Upon rolling over GREEN, a new dropdown populates with TALL, SHORT, MID. Upon that selection a 4th dropdown shows 34, 35, 36,37,38,39.
In a single cell selection the user now has defined 3 more data points tied to the initial selection without ever having to leave the first cell. WAY FASTER for the user than choose and now go to another cell row and scroll to find the next, then again, then again. I have seen it used in other applications, but I just can't find a way to do it in Sheets. If the answer is out there please point me to it.