Conditioning Formating
How do you set condition formating in a column using RAG bubbles for the following conditions:
- Green bubble should appear if the temperature is 118-130 F
- Yellow bubble if temperature is <118 F
- Red bubble if temp is 130 F
Answers
-
Hi @Vinton Douglas
Hope you are fine, please try the following formula and convert it to column format formula:
=IFERROR(IF(AND([temperature ( F )]@row >= 118, [temperature ( F )]@row <= 130), "Green", IF([temperature ( F )]@row > 130, "Red", "Yellow")), "")
The following screenshot shows the result:
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi Bassam,
This is excellent and what I am hoping to achieve. I am however unable to achieve the outcome results of the bubble when I insert the formulla. Are you available for me to share the sheet?
-
yes please share me as an admin and i will fix it for you. the conditional formatting column must be Symbol type ( RGB )
My Email: Bassam.k@mobilproject.it
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
i fix it for you please check, but you need to convert it to column format formula.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thank you very much Bassam,, you are a genius! The only issue I now discovered is that if the section under temperature remains blank after removing. an input, the bubble remains yellow. Please have a look at the shared sheet.. Grateful if the section under temperature where there is no input, for no yellow bubble to be displayed.
Thanks again.
-
Ok I will fix it tomorrow because am out now.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
I Fix it, please check:
=IFERROR(IF(temperature@row = "", "", IF(AND(temperature@row >= 118, temperature@row <= 130) ,"Green", IF(temperature@row > 130, "Red", "Yellow"))), "")
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!