Formula Only Column

ZachTenHaken
edited 12/09/19 in Smartsheet Basics

Hello!

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? 

 

Thanks!

 

Zach

Comments