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"))))
Help Article Resources
Check out the Formula Handbook template!