RGB Balls IF Function on 4 Colours Rules

Hello everyone, sorry if my grammar is bad. I am Chilean and I recently use Smartsheet, I have learned a lot in a short time. Now I need to solve this formula.

Grey = IF Stock Column is “ “ (empty)

Red = IF Stock Column is “0”

Yellow = IF Stock Column <= Critico Column

Green = IF Stock > Critico Column

Could you give me a hand

(see image)

Captura de Pantalla 2019-08-12 a la(s) 21.11.18.png

Find more posts tagged with

Formulas

Account and User Management

Comments

Nic Larsen

Try:

=IF(ISBLANK(Stock@row), "Grey", IF(Stock@row = 0, "Red", IF(Stock@row > Critico@row, "Green", "Yellow")

Gerardo_Clarke

First of all, thank you very much for your help. However, I tried and it doesn't work. Or I am doing something wrong (see image).

Nic Larsen

Hmm.. I do see a spelling error in my formula. I would also leave the @row versus using Stock8 for example. I tested this new one and it works.

Do you know if your formulas need to be separated by a ";" or a ","?

=IF(ISBLANK(Stock@row), "Gray", IF(Stock@row = 0, "Red", IF(Stock@row > Critico@row, "Green", "Yellow")))

Gerardo_Clarke

Many thanks ! you're absolutely right it's better use row@

Mike Wilday

You might also need to translate the colors into your language. When you click on the dropdown for the RYG symbol column, use whatever spelling is there. Those are the keywords you will need to use trigger those symbols. I helped someone yesterday who had a similar problem.

https://community.smartsheet.com/discussion/rgb-balls-format

Gerardo_Clarke

Yes, thanks, I had already learned it from you and had previously applied it. Thanks again

Mike Wilday

Awesome. Glad you got it figured out.

Sign in to join the conversation!

Quick Links

Trending discussions

Netdays Formula
I am wanting to calculate Netdays but only if there is data in 'Corrective Action 1' I am currently using this formula: =IF(ISBLANK([Date Action 1 Complete]@row ), NETDAYS([Date of Event]@row , TODAY()), NETDAYS([Date of Event]@row , [Date Action 1 Complete]@row )) How do I adjust it to only pull a date when Corrective…
Re-write a formula to make it Column Formula compatible
I have Concept phase projects that can result in multiple Phase 1 projects being generated from one Concept Review. I want to calculate the time in the Concept Phase for the first project from that Concept (the Approved Gate 0 UID), but mark it N/A for any subsequent references to that UID. I figured out the formula below…
How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.