Check Box Question
Can you make a requirement to fill out specific boxes before you are able to check the checkbox? So basically you can't check the box unless Column/Row A1 -- B19 -- and M24?
Answers
-
Possibly. Are you able to provide a screenshot with some mock data for reference?
-
So the column with the red and yellow highlighted check boxes are what I want to prevent from being checked until the boxes that are highlighted yellow filled out. Once their are all filled out, then it'll allow you to check the box.
-
You can't "lock" the cells quite like you are looking for, but you can use a formula and conditional formatting to "hide" the box until it is allowed to be checked.
For example, if I wanted to hide the box until the Contractor and Phase columns were populated, I would use a formula such as
=IF(AND(Contractor@row <> "", Phase@row <> ""), "", ".")
This will output a period if either (or both) of those cells are blank. Then I can use conditional formatting to change the text color to match the background color when the row has a period in it.
This will effectively "hide" the checkbox until both the Contractor and Phase cells are populated. Then it outputs a "" (blank) which will reveal the checkbox.
-
So I place the formula in the check box box? Sorry just trying to place the formula in the right area. Could I place as many boxes I need in there?
-
The formula would go into the checkbox, then you would use Conditional Formatting on the checkbox column.
I'm not sure what you mean by your second question though.
-
If I want to have 10 different cells to be filled out prior to the check box being unhidden, is that going to work?
-
Yes. You would just need to include those 10 cells in the IF/AND formula.
-
So for example of two of the cells, would this be correct?
=IF(AND([<- Subject*]246 <> "", [<- Actual Finish*]246 <> ""), "", ".")
-
That is correct. Basically you are saying that IF the first cell AND the second cell are NOT BLANK, then output a blank (which leaves the checkbox visible). Otherwise output a period (which hides the box when conditional formatting is set up.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!