Forum Discussion
Create a dropdown list from a formula
mathetes This is for internal use - no customers will be using it
The intent is to limit how a standard part is defined - to determine labor for installation on a separate sheet.
I think I'd still approach it the way I suggested.
I don't know how long your drop down list of standard parts is, whether it varies by some higher order of assembly (if so, see the attached example of what I've called Cascading Data Validation; this would enable you to have different sets of "Standard parts" for different major product categories), but to my way of thinking it still makes sense to offer the drop down list first, with the option of adding a description of the "Other" rather than asking the user--whether customer or not--to run through their own recollection of what's included under "Standard"