Help: formula to check box if a cell is NOT blank

yoyeeyee

I need to check the box if/when the cell is NOT blank anymore:

Nik Fuentes

try =if([Column1]@row<>"",1,0)

the "<>" character is "does not equal" and smartsheets recognizes "" as a blank cell

yoyeeyee

Worked perfectly! thank you so very much!!!!

Kirt Tassmer

just use a simple if statement in the check box column

=IF(ColumnName@row > 0, 1, 0)

or you could use

=IF(ISBLANK(ColumnName@row) = 1, 0, 1)

Nik Fuentes

try =if([Column1]@row<>"",1,0)

the "<>" character is "does not equal" and smartsheets recognizes "" as a blank cell

yoyeeyee

Worked perfectly! thank you so very much!!!!

yoyeeyee