Trying to Auto-Populate a symbol if another cell is blank


My goal is to make it so that if a cell in column 2 is blank then the column 1 of the same row auto-populates with the Grey Circle symbol, any help is appreciated :)


  • Matthew Rutledge

    Make sure column 1 is set as a symbol column with the gray ball included (as opposed to the set with blue) and then enter the formula below.

    =IF([column 2]@row = "", "Gray")

    If you set that formula as a column formula, it will populate automatically with every row of information that is added.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!