Nikhil2803
New Member
- Joined
- Jul 18, 2023
- Messages
- 36
- Office Version
- 365
- Platform
- Windows
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
=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