Dynamic Drop Down lists from another column either within the sheet or from another sheet
I've searched, but everyone seems to say that this is not an option at the moment, are there any work arounds?
I want to create a page where someone can create a product id number based on several factors, i.e. category, model number, color, country, end customer
I'f like osmeone to be able to select the category (call it YYY), then be presented with a list of options for model number (XXX), then select a color (CCC), a country (NNN), then end customer (MMM) if applicable, which would then display the final product id (YYYXXX-CCC-NNN-MMM would be the final output displayed)
Is this possible on a dashboard?