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?
Answers

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

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

@Josh LeFevre I agree with @DKazatsky as well.
Refer to this formula handbook, it's an awesome tool to help you create smartsheet formulas.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 438 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 451 Show & Tell
 30 Member Spotlight
 1 SmartStories
 282 Events
 32 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!