# Convert to Column Formula grayed out

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?

• @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!

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

• @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"))))

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

• @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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!