how to get the circle quarter symbols to change colour???

Stacy Meadows

Ok so I am using the below symbols with a formula in background to be in different qtrs/ stages of a project....

Background Formula is: =IFERROR(IF([%]@row <= 0.01, "Empty", IF([%]@row < 0.26, "Quarter", IF([%]@row < 0.51, "Half", IF([%]@row < 0.76, "Three Quarter", "Full")))), "")

However, I want to change the colour as I don't like the fact that they are greyscale as this is supposed to be a visual as such .... any ideas and suggestions are welcome?? please xx

Andrée Starå

Hi @Stacy Meadows

I hope you're well and safe!

Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

• Use Conditional Formatting to change the background
• Maybe use Emojis instead of Symbols

Would any of those options work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Stacy Meadows

I do not want to change background colour as I tried this and looks rubbish with the grey .... How can emaojis show me the progress of a project/ what stage it is at ?? :)

Andrée Starå

@Stacy Meadows

Ok.

Emojis can be used to replace the symbols, but unfortunately, there doesn't seem to be anything similar.

Here's an example of how it could work.

=IFERROR(IF([%]@row <= 0.01, "0️⃣", IF([%]@row < 0.26, "1️⃣", IF([%]@row < 0.51, "2️⃣", IF([%]@row < 0.76, "T3️⃣", " 🔵")))), "")

Make sense?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!