Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

If cell is not blank, checkbox

Options

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!

Tags:

Comments

  • Yasutaka Ito
    edited 03/11/17
    Options

    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
    J. Craig Williams ✭✭✭✭✭✭
    Options

    Olga,

     

    This formula should work

     

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

     

    for row 23.

     

    Hope this helps.

     

    Craig

This discussion has been closed.