I've got a table which users can enter data into. Each row represents an item.
I've got a column called 'lead times' where some times the lead times are weeks and sometimes they are days.
Ideally I want it to be a number that I can sort on, so I would have to bring all the numbers back to a universal point of reference - what's the best way to handle the mixture of lead times ?
I've thought of using a calendar 'popout' but this seems to add extra complication where its not needed. For instance if there is a 14 week lead time, if it was only 14 weeks a user could just type 14
but with a calendar they will have to flip through 3 months before they get to where they want to be. Any ideas how I can better handle this?