If cell is not blank, checkbox

Olga N Barabash

Hi,

 

I would like a formula in column1 that says, if column2 is not blank (meaning it has ANY text in it), check the box in column1.

 

Any ideas?

 

thanks!

Yasutaka Ito

Do the following.

 

Assuming that you're on the first row, place following formula in the Column1.

 

=ISBLANK([Column2]1) = false

 

The above formula's ISBLANK function evaluates [Column 2], which returns true when [Column 2] is empty/blank. Since we want to put a check mark on [Column 1] when [Column 2] is NOT blank, we are comparing the result of ISBLANK against "false".

 

Have a great day.

J. Craig Williams

Olga,

 

This formula should work

 

=IF(NOT(ISBLANK([column2]23)), 1, 0)

 

for row 23.

 

Hope this helps.

 

Craig