Trying to AutoPopulate a symbol if another cell is blank
Options
RB UMC
✭✭
My goal is to make it so that if a cell in column 2 is blank then the column 1 of the same row autopopulates with the Grey Circle symbol, any help is appreciated :)
Answers

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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!