Hi welcome. Thomas is asking this question of restricting access to a cell. If another cell is blank here's what the end result is. You have a name of something, you have the cost, and then we have some notes and we can say, Hey, this is an heavy item. Great. That works awesome. And you have another name of something. You have another cost, and then you say, Hey, we need to fix this great works. Great. But say you have a name and you don't have a cost. And you're like, we definitely need a cost before we put in any. So watch what happens here. Let's put in some notes cannot do it. How do we do this? I'll show you how restrict this column. We're gonna do it, sell by sell, but it'll be easy to copy and paste Restrict Access to a Cell if Another Cell is Blank Two Outputs, Same Cell

We know like, okay, in this cell B we we're gonna get a cost. If we have an item and we want C to be restricted until then, that's what we wanna do in this particular case. We're gonna right click. We're gonna go down to view more cell actions, data valid. and click on data validation , move my face over now in our criteria . Well, one thing I wanna point out is that we are using D two. Okay. We're in the D two cell and our criteria . We want to change this to custom formula . We're gonna do equals. Now the first thing I did was is blank. I just put a, is blank in here and I did C2, but this actually. Restrict Access to a Cell if Another Cell is Blank The Simplest Bestest Checklist in Google Sheets MESSIEST SPREADSHEET MISTAKE

Ended up being the exact opposite of what I wanted to do. , if we find out we do a custom formula and we're getting the exact opposite. All we have to do is put a NOT at the beginning this is blank now, right now I wanna show warning . The other thing I did was reject input . I'll show you that next. All I want to do is show warning . In this particular case, I wanna show you that it. now we have an item in C. We have a text in C2 we can do this. No problem whatsoever. Now let me delete that text. Let me copy and paste this down. We can actually do command C shift, command down arrow, and I can command V and now we have data validation everywhere we can actually right. Click. Data validation here and we'll see it shows up and check out this. Restrict Access to a Cell if Another Cell is Blank How To Hide Data with Checkboxes in Google Sheets You Should Know The Limitations of Data Validation

The cell range that I'm in right now is D five. The one before that was D two, the custom formula changes automatically. So if for a D five it's C five here, this is really helpful because we don't have to write this out every single time we can copy and paste and the rows are gonna change. Let's see if this actually works. Hello? Perfect. Hello? Perfect. Hello. We get a warning. This little red in the corner is our warning cells . Content violates its validation rules. Perfect. But we don't want the text to actually show up. We don't want just a warning and say, Hey you couldn't really do this. We want to reject every text. We want to make sure people filling this in know, Hey, you Restrict Access to a Cell if Another Cell is Blank The Simplest Bestest Checklist in Google Sheets You Should Know The Limitations of Data Validation

gotta go do the other thing. You gotta go fill in the other thing first. So let's do that. Let's do view more. Data validation . And all we're gonna do is change it from show warning to reject input . We can also actually, let me show you this. I'm gonna do one more step after this. Let's save that. Let's copy paste it. I'm gonna delete the text in there, but the data validation still remain. So we'll paste it all the way down and now we go, hello works. Hello works. Hello. Doesn't work and we get an error . The data you entered in CEL D four violates the data validation rules. This is a very general notice, right? Restrict Access to a Cell if Another Cell is Blank You Should Know The Limitations of Data Validation

We want more specific if, if someone else is using this sheet, And we haven't talked to 'em. We haven't told 'em what to do. We want the, the error , they get to be very explicit. What do they need to do to fix this thing? They're doing something now that's wrong, but , share with them something that is correct. We're gonna do one extra thing. We're gonna show validation , help. And here it says enter value that satisfies the formula . We don't want that. We want to write in some text, we wanna say, fill in C column first and hit save. Now we go, hello, it works. Hello. It works. Hello. the message has changed. Fill in C column first. Very general Hey, data validation rules were, ah, you didn't follow them. Restrict Access to a Cell if Another Cell is Blank Your First Formula in Google Sheets Introducing SheetFools MESSIEST SPREADSHEET MISTAKE

Now we can give an actual message of fill in the C column first. I'm filling this in. I know exactly what I need to do first. I need to fill in the. I think actually I can't do that because we have our other data validation there. , let's go back. We gotta do expensive can do awesome. We have now filled in the C column and go, hello. We can fill it in. This is really cool. Really fun and interesting way to add , steps and warnings into your sheet. If people have difficulties knowing what order to fill things in. Now you can stop them in their tracks right away and restrict access to a cell. If another cell is blank, this is really fun. If you have a good use case and you find this video, helpful comment down below how you're using this, what you're doing. Restrict Access to a Cell if Another Cell is Blank Make It Easier For Others To Use Your Google Sheets You Should Know The Limitations of Data Validation

Better Sheets

Resctrict Access to a Cell