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!
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.
Olga,
This formula should work
=IF(NOT(ISBLANK([column2]23)), 1, 0)
for row 23.
Hope this helps.
Craig
