Validations based on some checkbox from another sheet

[Nikhil2803]

I am working on validations for a cell in sheet 2. I have a checkbox in sheet 1 at C17 position. It has a format control at T17 cell which becomes True and False according to the checkbox clicked. the checkbox name is abc_chkbox. I am using the below validations, but it seems its not working.

=IF(AND('Configure (Goal)'!$C$12="Must Have",'Configure (Goal)'!$T$17=TRUE),IF(NOT(ISBLANK('Life and Disability Census'!$AB5)),NOT(ISBLANK('Life and Disability Census'!$AD5)),TRUE),TRUE)

Is 'Configure (Goal)'!$T$17=TRUE) is a correct command or TRUE will come within parenthesis. Also, will it work- 'Configure (Goal)'!abc_chckbox.Value=TRUE

 

[DanteAmor]

=IF(AND('Configure (Goal)'!$C$12="Must Have",'Configure (Goal)'!$T$17=TRUE), ...

That way is correct.

What I don't understand is what do you need when those 2 conditions are met and what do you need when one or the 2 conditions is not met.


--------------
I hope to hear from you soon.
Respectfully
Dante Amor
--------------