Formula Only Column

edited 12/09/19 in Smartsheet Basics


Can the entire column have the formula in each cell without it marking it as a new row?


Status Column = Drop-down Column

State Column = Symbols Column (with red/yellow/green symbols)


Goal: State column automatically updates based on Status column. 


Example:  If Status column says “sent for approval” then the my State column has a formula (not exact formula, just used for detail):

  • =IF(State Column 1 = “Sent for approval”, “Yellow”, IF(State Column 1 = “Approved”, “Green”, “Red”)),


Can this be in every cell in that column by default or do I always manually have to copy this formula to each new row added?