Add Smart Validated with airSlate SignNow

Limit dropdown document

today's video is more than just the basics of excels data validation I'm going to show you how you can get the content of the drop-down to be dynamic so if you add new categories they automatically show in the drop-down then I'm going to show you how you can validate for specific entries for example let's say the input date should fall in the future or numbers input should fall within a range or the input values should contain a specific number of characters imagine this imagine you work for the headquarters of a company that creates different types of apps and you have three divisions if the game productivity and utility divisions now you're responsible for collecting the information and the different types of projects that each company is working on you've created this template that includes the basic information you need to collect from them in the first column you have division you need to make sure that they type in the correct division that they don't make any spelling mistakes because some people could spell games instead of the game division right and you don't want to spend a lot of your time correcting these mistakes so here you want to add a drop-down list where the people can actually select the divisions for this you can add a data validation to do that you have to go to the data tab and underneath data tools you see something called data validation just click on it the first tab here is the Settings tab and you can see that by default Excel allows you to input any value in any of these cells but you can change that you could add in additional restrictions now you can see we have different options here you can also get very creative by adding in a custom check here using formulas but in this specific case we want to add a list this means we're adding our own drop-down now under source we have different option we could use cell referencing to keep things dynamic or we could input something directly in here so let's say these divisions are super static and they're hardly ever going to change I could actually type in game productivity and utility here and I just have to use my usual Excel separator between these okay I'm just gonna go with okay and I get this little down arrow here when I click it I can choose between the three different types of divisions now if these divisions were likely going to change so let's say it could be that I rename the game division to the games division it's better to use dynamic cell references and have these divisions somewhere in Excel cells but in this case I've added them to my master data tab and I've typed in the name of the division right here so now instead of fixing them I'm going to use cell references so let's go back to...