Home

Data validation lists

%3CLINGO-SUB%20id%3D%22lingo-sub-525772%22%20slang%3D%22en-US%22%3EData%20validation%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-525772%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20data%20validation%20to%20select%20cutomers%20via%20drop%20down%20list%20from%20a%20%22customers%22%20table.%20I%20would%20like%20to%20be%20able%20to%20add%20a%20new%20customer%20by%20typing%20in%20the%20name%20in%20the%20drop%20down%20list%20dialogue%20instead%20of%20going%20to%20the%20table%20to%20make%20a%20separate%20entry%20(that's%20what%20happens%20when%20I%20use%20AirTable%2C%20the%20option%20to%20add%20the%20item%20shows%20up%20when%20I%20start%20typing).%20Can%20it%20be%20done%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-525772%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-527213%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20validation%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-527213%22%20slang%3D%22en-US%22%3EYou%20may%20follow%20the%20instructions%20in%20this%20link%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsites.google.com%2Fsite%2Fe90e50fx%2Fhome%2Fexcel-data-validation-with-on-the-fly-update-without-vba%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsites.google.com%2Fsite%2Fe90e50fx%2Fhome%2Fexcel-data-validation-with-on-the-fly-update-without-vba%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-527237%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20validation%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-527237%22%20slang%3D%22en-US%22%3EThanks!%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
pamborides
New Contributor

I am using data validation to select cutomers via drop down list from a "customers" table. I would like to be able to add a new customer by typing in the name in the drop down list dialogue instead of going to the table to make a separate entry (that's what happens when I use AirTable, the option to add the item shows up when I start typing). Can it be done?

2 Replies
Thanks!
Related Conversations
Pulling data from one tab to another
krysphares in Excel on
6 Replies
force metadata when uploading files
Robert Lien in SharePoint on
10 Replies
Need help with formating colors based on time in columns
288088 in SharePoint on
18 Replies
SharePoint List View Filter Issue
Sam1209 in SharePoint on
8 Replies
Modern news web part any way to hide author
Theodor Ammerind in SharePoint on
6 Replies
Importing a spreadsheet into a SP Online list
Jlee_Prosci in SharePoint on
2 Replies