this is a very simple question. I have a column that lookup another table and I want to add another items to that column but I can’t because when I type a word the column does not find that item in the other table. I turned on “Allow quick adding of new items” on that lookup column options.
What I want is a sort of “Lookup OR manual input” or “Lookup Table1.Column1 OR Lookup Table2.Column1”
Any formula or idea to do this? I want to avoid add a new column only for some items.