Convert to Column Formula grayed out

Josh LeFevre

I'm trying to use Conditional Formatting on a Status column to change the color of the bubble based on the value of the Stage. I'm using the following and the option for Convert to Column Formula is grayed out:

IF([Stage]@row = 'Not Started', "Gray", IF(AND([Stage]@row = 'Testing'), "Yellow", IF(AND([Stage]@row ='Done'), "Green", IF(AND([Stage]@row = 'Blocked'), "Red"))))

Any suggestions?

Samuel Mueller

@Josh LeFevre just want to confirm that you actually have an = sign before the formula

=IF([Stage]@row = 'Not Started', "Gray", IF(AND([Stage]@row = 'Testing'), "Yellow", IF(AND([Stage]@row ='Done'), "Green", IF(AND([Stage]@row = 'Blocked'), "Red"))))

If it's not in the syntax of a formula it will not let you make it a column formula

Let me know if that works!

Josh LeFevre

I thought the same thing, but I'm getting an #UNPARSEABLE error when adding the equal sign.

Samuel Mueller

@Josh LeFevre sorry I didn't look at the actual formula

try this

=IF([Stage]@row = "Not Started", "Gray", IF([Stage]@row = "Testing", "Yellow", IF([Stage]@row ="Done", "Green", IF([Stage]@row = "Blocked", "Red"))))

DKazatsky

Additionally,

The singles quotes in your logical expression are going to cause #UNPARSEABLE once you have the "=" sign before the formula. Change those to double quotes.

Hope that helps,

Dave

Samuel Mueller

@Josh LeFevre I agree with @DKazatsky as well.

Refer to this formula handbook, it's an awesome tool to help you create smartsheet formulas.

Setup: Formula Handbook - Smartsheet.com