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

Options

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 :)

Answers

  • Matthew Rutledge
    Options

    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!