enum struggle. So I have a list of items that I want the user to be able to enter items or pick from the list. Easy enough. The issue is that as that list gets longr and longer I want to restrict it to items that have already been created based on the previous enum or enter a new one. using =SELECT(Completion List[Description],[Contractor]=[_THISROW].[Contractor])
I get the data I expect but no option to enter a new one. If I remove this code it works again. why can’t I have both functions?