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

yoyeeyee · 12/08/21

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

Nik Fuentes · 12/08/21

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

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

yoyeeyee · 12/08/21

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

Kirt Tassmer · 12/08/21

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 · 12/08/21

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

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

yoyeeyee · 12/08/21

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

yoyeeyee · 12/08/21

Best Answers