we use calc as our timesheet our architecturial company.
In the field we use to describe the work done for a certain time, we have a drop menu with certain items we can choose from.
I would like to know if it would be possible for the list to show certain options based on information entered in a previous field? So for arguments sake I enter “A” into a field, I only want option 1,2,5 and 7 to show and when I enter “B” I want option 2,7,9 and 10 to show
thanks in advance for any help!