RGB Balls Format

rgb balls format

I have not been able to set the "status" column to show the RGB balls after programming an IF formula as I show it in the attached images.

As you can see the column is edited as Status RGB but the result is delivered in text and not in color balls.

I appreciate your prompt help

Find more posts tagged with

Formulas

Try changing your formula to use the Spanish translations for Red, Yellow, Green. Since that is what is showing in your dropdown. Did that work?

PERFECT !!! thank you so much.

Yay. I'm glad I could get that working for you!

IF/OR Formula issue
Hi, I'm trying to pull data from another sheet if the date meets the criteria in one of two columns of 12/20/2025. Should I use an if/or or nested ifs? Here is what I have so far but get the #INCORRECT ARGUMENT SET error. Here's what I have so far. Any idea what I'm doing wrong? =IF(OR(INDEX({cutdate}, MATCH([Job ID]@row ,…
Average Formula
I am looking to get a formula on my metric sheet cross referenced from the survey results sheet. I am looking to get it as a number average but also separately a percentage as well. One thing to keep in Mind is that each column is a question where they would answer a 1-5 option. On the metric sheet it is separated into…
Sheet Summary Formula capturing dates before current expiry date column
Hi all, I thought I had this one down but I keep getting an error message. This is a sheet summary formula. Any ideas what I am doing wrong? =COUNTIF([CURRENT EXPIRY]:[CURRENT EXPIRY], >TODAY) Thank you!