RYGB labeling

Nathan Winegar

Is there a way to label the RYBG dots so that when you choose the color dot a text shows up beside it as well in the same cell?

Simple example: Red - Stop; Yellow- Caution; Green - Go; Blue - Sky

Andrée Starå

Hi Nathan,

Yes, but you’d need to use emojis/special characters for it to work.

Would that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Nathan Winegar

Hi Andree,

Where/how would I input those emojis/special characters? I don't see anywhere to edit.....

Andrée Starå

Try something like this.

=IF(Status@row = "Blue"; "🔵- Sky")

The same version but with the below changes for your and others convenience.

=IF(Status@row = "Blue", "🔵- Sky")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

It will show something like this.

To access the Emojis.

Mac: Command - Control - Spacebar 

PC: Press, “Windows Logo + Dot” keys or “Windows Logo + Colon” keys.

Did that work?