Save eSign Checkbox with airSlate SignNow

Add checkbox accreditation

so in this video we're going to learn how to use checkboxes for data validation and also how to create something more user interactive so right now what we have here is this data set and on top we have this little summary of our data set so by default we have the total for each region in our data set and the way this is going to work if we click on the check box here on the right it's gonna add it to the grand total and it's gonna highlight that in our data set now if I check Western that will add it to the grand total as well and you can see how Western is highlighted we can also check any other box so if I check all the boxes it's gonna add all of them to our total and everything isn't gonna be colored so basically it's a nice way for us to visually see what exactly we're adding up together as we're checking the boxes and it's I guess more user interactive let's get going here's our data set and check boxes are a part of data validation so if I click in a cell go under data and data validation and choose a criteria I can switch it to check box and hit save and that's gonna add a check box now you can check it or uncheck it now let's see actually I'm gonna undo this I want to show you something I'm gonna do this again I'm gonna do data validation and switch it to check box so let's see what's the value in that box so I'm gonna go here and do equal sign and click on that box hit enter so you can see right now it's blank there's nothing in there if I check the box its true if I uncheck the box it's false so the initial State if you never clicked on the box it's gonna be just blank but once you check that it's true and uncheck that it's false all right so let's keep that in mind because we're gonna need this so let's try to just get a list of our regions I'm just gonna copy and paste this here so I could just type all those names but I'm not gonna do that so I'm going to use unique function and I just need a clean list out of all of these regions I'll just do this hit enter that gives me a clean list now I can just take this and copy and paste values only so now there are no formulas left here it's just clean cells so here I want to have my check boxes and total values for each one of those regions so I'll probably have check boxes over here and have totals over here so I'll just type total sales here we'll have our check boxes so I'm going to select that area data data validation...